I want to add totals using several criteria from different column
 

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!

I want to add totals using several criteria from different column
 

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

"Looker1" wrote:

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!

I want to add totals using several criteria from different column
 

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:

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!

I want to add totals using several criteria from different col
 

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

"Joel" wrote:

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

"Looker1" wrote:

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!