Complicated (I think) formula (Excel 2002)

H

Helen

I have a spending journal structured by day. Included in the columns are
Amount Spent and Category (worksheet 1).

In preparation for creating a pie chart, I need to sum each category
(worksheet 2).

I'm looking for a formula that will look at the category and, if it matches
the criteria (i.e., Eat Out), will include the amount spent in the sum.
 
P

porter444

Try this:
SUMIF(range,criteria,sum_range)

Example:
=SUMIF(A1:A15,"Eat Out",B1:B15)
 

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

Top