How do I add specific categories from several worksheets?
 

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?

How do I add specific categories from several worksheets?
 

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?

"Crys H." wrote:

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?

How do I add specific categories from several worksheets?
 

hi Crys,

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

hth
regards from Brazil
Marcelo

"Crys H." escreveu:

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?

How do I add specific categories from several worksheets?
 

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

regards

"Crys H." escreveu:

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?

How do I add specific categories from several worksheets?
 

How are the sheet tabs named?

In article ,
Crys H. <Crys wrote:

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?

How do I add specific categories from several worksheets?
 

Thanks I've got it now!
--
"If you make something idiot proof, someone will invent a better idiot."


"Barb Reinhardt" wrote:

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?

"Crys H." wrote:

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?