How do I add specific categories from several worksheets?

C

Crys H.

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?
 
B

Barb Reinhardt

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?
 
M

Marcelo

hi Crys,

=sunif(b:b,"fuel",C:C)

hth
regards from Brazil
Marcelo

"Crys H." escreveu:
 
M

Marcelo

sory on the previous post I type sunif, the correct is SUMIF

regards

"Crys H." escreveu:
 
Top