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!

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!

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!

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!