I just looked at your file, and...
=SUMIF(CategoryRange,"="&[Category],WithdrawalRange)
seems to be working just file for all cells...
A B 10 Category Total 11 Deposit $ 6,362.06 12 Mortgage $ 600.00 13 Fuel $ 251.02 14 Food & Drinks $ 719.26 15 Our Boys $ 680.00 16 Utilities $ 236.52 17 Credit Card $ - 18 Wedding $ 276.93 19 Garage $ 66.00 20 Clothes & Shoes $ 170.20 21 Cash $ - 22 Other $ 23.48
Bookmarks