Let's say I have the following:
A B C D
26Nov2007 Wal-Mart Groceries $121.26
26Nov2007 AT&T Cell Phone $96.90
26Nov2007 Wal-Mart Groceries $86.59
26Nov2007 Veolia Waste Garbage $52.25
26Nov2007 Locos Deli and Pub Dining Out $51.47
26Nov2007 Chase Bank Loan $50.00
26Nov2007 Target Household $21.39
26Nov2007 Shell Oil Gas Money $42.41
Let's say I want to know how much I spent total on Groceries. The following formula works:
=SUMIF(C:C,"Groceries",D:D)
If I type that formula in a blank cell on that worksheet, it works. However, I want to display the total I spent on groceries on a different worksheet within the same workbook. For the sake of clarity, the above is on "Worksheet1" and I want to sum the amount I spent on groceries and display that value on "Worksheet2". How do I do that?
Thanks!
Bookmarks