View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
redlights redlights is offline
external usenet poster
 
Posts: 4
Default 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