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.

Thank you very much for any help you can provide.
gina