How do I add specific categories from several worksheets?

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

Guest

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

Guest

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

regards

"Crys H." escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To be able to Total amount of occurrences in a dropdown list & total costs 0
VLookup Data, Find 2 Adjacent Rows, Return Value in 1 Row 3
How to Combine Cells of Information in Excel 5
How do I sum a date specific range of cells? 3
Help with Ledger/accounting formulas 5
Formula to combine cells (A challenge!) 5
how do i change the value of a cell with a checkbox 3
Show only cells greater than zero 1

Top