A lookup table to subtotal categories??

[char in the moon valley]

Here's what I want to do... I use Excel to track expenses. Column heading are "Date," "Type" and "Amount". Under "type" I enter a category like "food", "gasoline", "groceries". Like a checkbook register except each entry gets categorized.

On a separate sheet I'd like to keep a running total of how much I've spent on food, gasoline or groceries. So I need to tell Excel to look at each entry in column B, and if it says "food" add it to the total in cell xx

I know (basically) how to use lookup tables, but I can't think of how this is going to work. Anyone help?

Thanks!!!

 

[acw]

H

Have a look at the sumif function

Tony

 

[char in the moon]

Thanks. I had a feeling it was going to be a no-brainer!

 

[Frank Kabel]

Hi
one easy solution could be using Pivot Tables (go to 'Fata - Pivot
Table).
1. Select your table
2. Use the Type as row for the pivot table
3. Use Amount (Sumof Amount) as data

For further help on Pivot tables have a look at the Excel help or
http://www.cpearson.com/excel/pivots.htm

Frank