Gina wrote:
I have a workbook containing personal expenses. The first worksheet is a
summary and the others are expenses by month. here is a sample
B C
Action Amount
Grocery 10.19
Grocery 100.32
Books 4.99
Dining out - Dinner 17.00

I just enter a new row for each expense including the info above as well as
date, money source etc...

What I would like to do is create a formula that would look for any
"grocery" action and then add the corresponding amount to the "grocery"
expense category on my summary page located in cell I11.

The second thing I would like to do is deduct that same amount from my bank
account total which is in cell C11.

Hi Gina

In cell I11 put something like this:

=SUMIF(Sheet1!B1:B4,"Grocery",Sheet1!C1:C4)

Amend your sheet reference and ranges as necessary.

In C11 (your bank account summary) just reference I11 e.g.

=WhateverElseMakesUpYourAccountSummary-I11

Hope that helps

Regards

Steve