I want to add totals using several criteria from different column

L

Looker1

I am using excel, on XP 2003 SP2 (might be 3)

I am trying to add amounts together using several criteria. I have a column
called "sales type" (of which there are many types) I then have a column of
the month they are paid (Jan, Feb, Mar, etc.etc.)

I want to show in a cell the sales value of a "sales type" in a given
"month" using a formula instead of selecting each cell manually and adding it
to a simpl addition sum string.

Any help much appreciated!
 
J

Joel

if your data is in rows 1 to 100

=sumproduct(--(A1:A100="Mar"),--(B1:B100="Sales type"),C1:C100)

"Mar" can be replaced with a cell reference
"Sales type" can be replaced with any strign of a cell reference
C1:C100 is the column of values to add
 
M

Marcelo

two ways
1st and easy Pivot Table.

2nd
assuming:

Sales type column A
month column B
values Column C
=sumproduct(--(a2:a1000="sales type")*("b2:b1000="month"),(c2:C1000))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Looker1" escreveu:
 
L

Looker1

Thank you Joel, you have spared my PC from being launched from my office
window into the street below!
 

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