Spreadsheet: 489025d1479018028-sumifs-returning-0-excel-forum
Sheet: Data

Date | Amount | Category
2016-08-06 00:00:00 | 146.98 | Apparel |  | Attempted SUMIFS Forumlas
2016-08-06 00:00:00 | 58.72 | Apparel |  | Both Criteria |  | *This should not be zero
2016-08-13 00:00:00 | 27.22 | Apparel |  | First Criteria
2016-08-18 00:00:00 | 13.38 | Apparel |  | Second Criteria
2016-08-18 00:00:00 | 93.07 | Apparel
2016-08-18 00:00:00 | 33.58 | Apparel
2016-08-22 00:00:00 | 37.5 | Apparel
2016-08-22 00:00:00 | 79.97 | Apparel
2016-09-03 00:00:00 | 279.5 | Apparel
2016-09-03 00:00:00 | 146.92 | Apparel
2016-09-03 00:00:00 | 77.25 | Apparel
2016-09-04 00:00:00 | 250 | Apparel
2016-09-04 00:00:00 | 130 | Apparel
2016-09-04 00:00:00 | 42.98 | Apparel
2016-09-05 00:00:00 |  | Apparel
2016-09-25 00:00:00 |  | Apparel
2016-10-16 00:00:00 | 42.5 | Apparel
2016-10-16 00:00:00 | 60 | Apparel
2016-10-19 00:00:00 | 101.25 | Apparel
2016-10-31 00:00:00 | 538.93 | Apparel
2016-08-06 00:00:00 | 100.17 | Beauty
2016-08-13 00:00:00 | 28.8 | Beauty
2016-09-18 00:00:00 | 112.14 | Beauty
2016-10-01 00:00:00 | 10.89 | Beauty
2016-08-18 00:00:00 | 50.29 | Bills/Apt
2016-08-23 00:00:00 | 81.29 | Bills/Apt
2016-09-18 00:00:00 | 60.29 | Bills/Apt
2016-09-23 00:00:00 | 140 | Bills/Apt
2016-10-18 00:00:00 | 60.29 | Bills/Apt
2016-10-23 00:00:00 | 140 | Bills/Apt
2016-08-01 00:00:00 | 61.5 | Cash
2016-08-01 00:00:00 | 20 | Cash
2016-08-01 00:00:00 | 26 | Cash
2016-08-01 00:00:00 | 26.7 | Cash
2016-08-05 00:00:00 | 62 | Cash
2016-08-08 00:00:00 | 63 | Cash
2016-08-08 00:00:00 | 5 | Cash
2016-08-11 00:00:00 | 5 | Cash
2016-08-22 00:00:00 |  | Cash
2016-08-26 00:00:00 | 150 | Cash
2016-08-29 00:00:00 | 101.5 | Cash
2016-08-29 00:00:00 | 20 | Cash
2016-08-30 00:00:00 |  | Cash
2016-08-30 00:00:00 |  | Cash
2016-09-06 00:00:00 | 13 | Cash
2016-09-07 00:00:00 | 32 | Cash
2016-09-09 00:00:00 | 60 | Cash
2016-09-12 00:00:00 | 13.5 | Cash
2016-09-15 00:00:00 | 61.75 | Cash
2016-09-21 00:00:00 | 61.99 | Cash
2016-09-27 00:00:00 | 405.2 | Cash
2016-09-29 00:00:00 |  | Cash
2016-09-29 00:00:00 |  | Cash
2016-10-20 00:00:00 |  | Cash
2016-10-24 00:00:00 |  | Cash
2016-10-27 00:00:00 | 103.5 | Cash
2016-10-28 00:00:00 |  | Cash
2016-10-28 00:00:00 |  | Cash
2016-08-01 00:00:00 | 1200 | Description
2016-08-30 00:00:00 | 1200 | Description
2016-08-06 00:00:00 | 19.68 | Dining
2016-08-06 00:00:00 | 12.61 | Dining
2016-08-11 00:00:00 | 7.89 | Dining
2016-08-12 00:00:00 | 9.25 | Dining
2016-08-13 00:00:00 | 3 | Dining
2016-08-13 00:00:00 | 2.75 | Dining
2016-08-13 00:00:00 | 15.65 | Dining
2016-08-14 00:00:00 | 8.26 | Dining
2016-08-14 00:00:00 | 5.44 | Dining
2016-08-15 00:00:00 | 14.38 | Dining
2016-08-21 00:00:00 | 13.97 | Dining
2016-08-22 00:00:00 | 37.58 | Dining
2016-08-24 00:00:00 | 40.45 | Dining
2016-08-27 00:00:00 | 6.31 | Dining
2016-08-28 00:00:00 | 6.38 | Dining
2016-08-29 00:00:00 | 9.8 | Dining
2016-09-01 00:00:00 | 14.26 | Dining
2016-09-02 00:00:00 | 29.37 | Dining
2016-09-03 00:00:00 | 47.92 | Dining
2016-09-03 00:00:00 | 7 | Dining
2016-09-04 00:00:00 | 5.5 | Dining
2016-09-04 00:00:00 | 17.64 | Dining
2016-09-08 00:00:00 | 28.68 | Dining
2016-09-08 00:00:00 | 17.42 | Dining
2016-09-10 00:00:00 | 50.1 | Dining
2016-09-13 00:00:00 | 18.78 | Dining
2016-09-16 00:00:00 | 32.63 | Dining
2016-09-17 00:00:00 | 2.99 | Dining
2016-09-24 00:00:00 | 26.29 | Dining
2016-09-24 00:00:00 | 19.76 | Dining
2016-09-28 00:00:00 | 7.75 | Dining
2016-10-05 00:00:00 | 25.05 | Dining
2016-10-11 00:00:00 | 5.31 | Dining
2016-10-13 00:00:00 | 31.18 | Dining
2016-10-16 00:00:00 | 8.18 | Dining
2016-10-16 00:00:00 | 8.15 | Dining
2016-10-22 00:00:00 | 8.05 | Dining
2016-10-22 00:00:00 | 20.65 | Dining
2016-10-23 00:00:00 | 10.99 | Dining
2016-10-26 00:00:00 | 36.12 | Dining
2016-10-29 00:00:00 | 22.64 | Dining
2016-08-12 00:00:00 | 12 | Drinks
2016-08-13 00:00:00 | 12 | Drinks
2016-08-15 00:00:00 | 17.42 | Drinks
2016-08-21 00:00:00 | 13.07 | Drinks
2016-08-27 00:00:00 | 14 | Drinks
2016-08-31 00:00:00 | 14.69 | Drinks
2016-09-03 00:00:00 | 44 | Drinks
2016-09-10 00:00:00 | 16 | Drinks
2016-09-10 00:00:00 | 12.89 | Drinks
2016-09-12 00:00:00 | 26.12 | Drinks
2016-09-20 00:00:00 | 14.14 | Drinks
2016-09-24 00:00:00 | 33.4 | Drinks
2016-09-25 00:00:00 | 25.44 | Drinks
2016-10-20 00:00:00 | 16 | Drinks
2016-10-20 00:00:00 | 13 | Drinks
2016-10-22 00:00:00 | 20.76 | Drinks
2016-10-26 00:00:00 | 14.7 | Drinks
2016-10-30 00:00:00 | 22.85 | Drinks
2016-08-13 00:00:00 | 5.39 | Drug Stores
2016-08-25 00:00:00 | 25.76 | Drug Stores
2016-08-28 00:00:00 | 39.99 | Drug Stores
2016-09-28 00:00:00 | 20.92 | Drug Stores
2016-09-28 00:00:00 | 4.75 | Drug Stores
2016-10-15 00:00:00 | 13.53 | Drug Stores
2016-08-03 00:00:00 | 52.49 | Groceries
2016-08-05 00:00:00 | 9.25 | Groceries
2016-08-08 00:00:00 | 31.26 | Groceries
2016-08-14 00:00:00 | 16.09 | Groceries
2016-08-27 00:00:00 | 9 | Groceries
2016-08-29 00:00:00 | 37.14 | Groceries
2016-08-30 00:00:00 | 9.25 | Groceries
2016-09-01 00:00:00 | 7.08 | Groceries
2016-09-17 00:00:00 | 66.66 | Groceries
2016-09-19 00:00:00 | 7.62 | Groceries
2016-09-19 00:00:00 | 19.46 | Groceries
2016-09-30 00:00:00 | 21.02 | Groceries
2016-10-05 00:00:00 | 101.5 | Groceries
2016-10-10 00:00:00 | 59.23 | Groceries
2016-10-17 00:00:00 | 8.78 | Groceries
2016-10-23 00:00:00 | 12.19 | Groceries
2016-10-23 00:00:00 | 100.2 | Groceries
2016-10-30 00:00:00 | 23.7 | Groceries
2016-10-30 00:00:00 | 31.07 | Groceries
2016-10-30 00:00:00 | 19.96 | Groceries
2016-08-13 00:00:00 | 43.54 | Hobbies
2016-09-16 00:00:00 | 9.78 | Hobbies
2016-10-25 00:00:00 | 11.37 | Hobbies
2016-08-02 00:00:00 | 10.9 | Lunch
2016-08-03 00:00:00 | 7.46 | Lunch
2016-08-04 00:00:00 | 11.98 | Lunch
2016-08-09 00:00:00 | 4.5 | Lunch
2016-08-11 00:00:00 | 23.77 | Lunch
2016-08-11 00:00:00 | 8.05 | Lunch
2016-08-12 00:00:00 | 4 | Lunch
2016-08-12 00:00:00 | 8.46 | Lunch
2016-08-16 00:00:00 | 13.65 | Lunch
2016-08-16 00:00:00 | 6 | Lunch
2016-08-22 00:00:00 | 11.75 | Lunch
2016-08-23 00:00:00 | 8.74 | Lunch
2016-08-23 00:00:00 | 8.5 | Lunch
2016-08-23 00:00:00 | 3 | Lunch
2016-08-24 00:00:00 | 7.5 | Lunch
2016-08-24 00:00:00 | 3 | Lunch
2016-08-24 00:00:00 | 10 | Lunch
2016-08-25 00:00:00 | 7.5 | Lunch
2016-08-26 00:00:00 | 8.96 | Lunch
2016-08-29 00:00:00 | 11.98 | Lunch
2016-08-31 00:00:00 | 10.75 | Lunch
2016-09-02 00:00:00 | 4.5 | Lunch
2016-09-06 00:00:00 | 10.9 | Lunch
2016-09-10 00:00:00 | 17.96 | Lunch
2016-09-13 00:00:00 | 13.65 | Lunch
2016-09-14 00:00:00 | 4.5 | Lunch
2016-09-14 00:00:00 | 9 | Lunch
2016-09-15 00:00:00 | 13 | Lunch
2016-09-21 00:00:00 | 3 | Lunch
2016-09-22 00:00:00 | 4.75 | Lunch
2016-09-23 00:00:00 | 11.98 | Lunch
2016-09-26 00:00:00 | 12.59 | Lunch
2016-09-26 00:00:00 | 4.25 | Lunch
2016-10-04 00:00:00 | 5.75 | Lunch
2016-10-05 00:00:00 | 9.5 | Lunch
2016-10-11 00:00:00 | 12.25 | Lunch
2016-10-17 00:00:00 | 12 | Lunch
2016-10-18 00:00:00 | 13.17 | Lunch
2016-10-19 00:00:00 | 4.5 | Lunch
2016-10-21 00:00:00 | 10.9 | Lunch
2016-10-24 00:00:00 | 17.42 | Lunch
2016-10-25 00:00:00 | 10 | Lunch
2016-10-26 00:00:00 | 12.5 | Lunch
2016-10-27 00:00:00 | 4.08 | Lunch
2016-10-27 00:00:00 | 14.14 | Lunch
2016-08-11 00:00:00 | 9.99 | [NAME]. Shopping
2016-08-11 00:00:00 | 25 | [NAME]. Shopping
2016-08-12 00:00:00 | 42.82 | [NAME]. Shopping
2016-08-15 00:00:00 | -27 | [NAME]. Shopping
2016-08-16 00:00:00 | 22.64 | [NAME]. Shopping
2016-08-21 00:00:00 | 2.65 | [NAME]. Shopping
2016-08-21 00:00:00 | 65.84 | [NAME]. Shopping
2016-08-21 00:00:00 | 20.93 | [NAME]. Shopping
2016-09-05 00:00:00 |  | [NAME]. Shopping
2016-09-06 00:00:00 | 9.5 | [NAME]. Shopping
2016-09-06 00:00:00 | 29.83 | [NAME]. Shopping
2016-09-10 00:00:00 | -9.99 | [NAME]. Shopping
2016-09-19 00:00:00 | 31.56 | [NAME]. Shopping
2016-10-03 00:00:00 | 40.95 | [NAME]. Shopping
2016-10-03 00:00:00 | 79.46 | [NAME]. Shopping
2016-10-05 00:00:00 | 16.28 | [NAME]. Shopping
2016-10-14 00:00:00 | 12.78 | [NAME]. Shopping
2016-10-15 00:00:00 | 36.96 | [NAME]. Shopping
2016-10-18 00:00:00 | 22.06 | [NAME]. Shopping
2016-10-19 00:00:00 | 29.94 | [NAME]. Shopping
2016-10-20 00:00:00 | 126.98 | [NAME]. Shopping
2016-10-27 00:00:00 | 13.17 | [NAME]. Shopping
2016-08-03 00:00:00 | 1.57 | Miscellaneous
2016-08-09 00:00:00 | 33.73 | Miscellaneous
2016-08-15 00:00:00 | 0.99 | Miscellaneous
2016-08-26 00:00:00 | 4.7 | Miscellaneous
2016-08-31 00:00:00 | 4.99 | Miscellaneous
2016-09-08 00:00:00 | 17.99 | Miscellaneous
2016-09-14 00:00:00 | 12 | Miscellaneous
2016-09-15 00:00:00 | 0.99 | Miscellaneous
2016-09-20 00:00:00 | 16.49 | Miscellaneous
2016-10-06 00:00:00 | 41.43 | Miscellaneous
2016-10-13 00:00:00 | 4.34 | Miscellaneous
2016-10-15 00:00:00 | 9.36 | Miscellaneous
2016-10-15 00:00:00 | 0.99 | Miscellaneous
2016-10-22 00:00:00 | 93.52 | Miscellaneous
2016-10-27 00:00:00 | 21.76 | Miscellaneous
2016-08-07 00:00:00 | 130.62 | Personal Care
2016-08-27 00:00:00 | 52.89 | Personal Care
2016-09-14 00:00:00 | 12 | Tickets
2016-09-20 00:00:00 | 3 | Tickets
2016-09-25 00:00:00 | 6 | Tickets
2016-08-04 00:00:00 | 9.96 | Transportation
2016-08-05 00:00:00 | 13.77 | Transportation
2016-08-07 00:00:00 | 12.48 | Transportation
2016-08-11 00:00:00 | 13.55 | Transportation
2016-08-11 00:00:00 | 10.22 | Transportation
2016-08-11 00:00:00 | 6.46 | Transportation
2016-08-13 00:00:00 | 17.16 | Transportation
2016-08-13 00:00:00 | 9.99 | Transportation
2016-08-30 00:00:00 | 4 | Transportation
2016-08-31 00:00:00 | 11.22 | Transportation
2016-09-09 00:00:00 | 13.54 | Transportation
2016-09-15 00:00:00 | 9.62 | Transportation
2016-09-23 00:00:00 | 12.36 | Transportation
2016-10-14 00:00:00 | 9.36 | Transportation
2016-10-17 00:00:00 | 8.15 | Transportation
2016-10-19 00:00:00 | 10.15 | Transportation
2016-10-20 00:00:00 | 17.16 | Transportation
2016-10-20 00:00:00 | 8.6 | Transportation
2016-10-22 00:00:00 | 8.16 | Transportation
2016-10-23 00:00:00 | 5 | Transportation
2016-10-23 00:00:00 | 4.2 | Transportation
2016-10-23 00:00:00 | 2.6 | Transportation
2016-10-29 00:00:00 | 9.14 | Transportation
2016-10-30 00:00:00 | 9.14 | Transportation
2016-10-30 00:00:00 | 9.14 | Transportation
2016-10-31 00:00:00 | 6.12 | Transportation
2016-10-31 00:00:00 | 12.01 | Transportation
2016-08-17 00:00:00 | 14.75 | Travel
2016-09-26 00:00:00 | 133.34 | Travel
2016-09-30 00:00:00 | 12.54 | Travel
2016-10-06 00:00:00 | 16.94 | Travel
2016-10-09 00:00:00 | 1.94 | Travel
2016-10-09 00:00:00 | 19.03 | Travel
2016-10-11 00:00:00 | 9.04 | Travel