G
Gina
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
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