Formula for budgets
I am trying to create a formula that will reference my daily budget sheet. I
would like the formula to add up all the categories individually. Or in
other words, taking all the costs that are a part of one category and placing
them into my monthly budget sheet.
For example: Lets say I have four columns: A:DATE, B:DESCRIPTION, C:COST,
and D:CATEGORY. For all the DINING OUT costs, which are labeled with a
"dining out category", I want them to automatically sum up into my Monthly
budget sheet in the corresponding cell "DINING OUT" actual costs.
I would like to do that for all my categories.
Thanks
|