How do I add specific categories from several worksheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to help someone calculate her expenses. In column A she has
the date the expense occured, in column B she has the type of expense, and in
column C she has the dollar amount. She has a spreadsheet for each month.
How do I calculate the values for one expense (for example, the amount spent
on fuel) for the entire year?
 
Let's say she has the actual expenses in B2:B100 and the expense type in
A2:A100

This will give her what she needs on a monthly basis.
=sumproduct(--(A2:A100="FUEL"),(B2:B100))

You'd have to pull the data from each sheet to get the sum for the yearly
reports. As I'm not sure how it's listed in the spreadsheets, I can't give a
good answer to you. Can you give more information?
 
Back
Top