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!