Thread: Adding Values Based on Criteria

Hi,

I have four columns, description, category, date and amount, on another worksheet I have two columns category and amount. What I want to do is to find any rows in the first worksheet where the value of the cell in the 'category' column is grocery, for example, and add the values in the 'amount' column and put the sum in the 'amount' column in the second worksheet.

I've done this before and don't remember it being as difficult to figure out as it is this time, I've been trying formulas like this:

=IF(June!B3:B39="Grocery",SUM(June!C3:C39),0)

If someone can tell me where I'm going wrong here I'd appreciate the help, thanks.

Cat

Nevermind... figured it out - SUMIF