How can I do this Formula???

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

Guest

I am hoping all of you smart excel buffs can answer this for me...

If I have a chart with COLUMNS labeled...
1) Name 2)price 3) category

How can I have all of the items prices (2) in a certain categroy (3) summed?

So that ...all of each category is added up?

Info Amount Cat
Staples 19.20 1
Officmax 106.91 1
Pictures 70.00 2
Classic Photgraphy 300.00 2
Website Yearly 840.00 2
Superfresh 45.06 3
Price Chopper 62.80 3
Shoprite 70.63 3
Walmart 0.74 4
AC moore 37.61 4
 
Hi

Either
=SUMIF(C:C,3,B:B)
or
=SUMPRODUCT((C2:C1000=3)*B2:B1000)
 
I am hoping all of you smart excel buffs can answer this for me...

If I have a chart with COLUMNS labeled...
1) Name 2)price 3) category

How can I have all of the items prices (2) in a certain categroy (3) summed?

So that ...all of each category is added up?

Info Amount Cat
Staples 19.20 1
Officmax 106.91 1
Pictures 70.00 2
Classic Photgraphy 300.00 2
Website Yearly 840.00 2
Superfresh 45.06 3
Price Chopper 62.80 3
Shoprite 70.63 3
Walmart 0.74 4
AC moore 37.61 4
Click to expand...

You might look at Pivot Table reports:

Cat Amount
1 126.11
2 1210
3 178.49
4 38.35
GT 1552.95

--ron
 
You must log in or register to reply here.

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

Sumproduct error 2
how i do this in EXCEL 4
Markup/Cost formula help... 1
Can a formula do this? 1
How do I do this? 3
How do I create the formula for this calculation? 1
How do I return multiple occurrences of a match in an array? 1
How can I sum repeat rows? 2

Back
Top