How do I count letters and numbers in a formula?
 

D I J M O <--column
How Type SP Bid Status <--Label
PM 21 AF 100 P
SC 41 AF 1000 L
CQ 11 DP 750 S

How do I get the sales totals for this? Count column D if it equals PM,
column I equals 21, and column O equals S, = sum column M. Please help.

How do I count letters and numbers in a formula?
 

Try...

=SUMPRODUCT(--(D2:D4="PM"),--(I2:I4=21),--(O2:O4="S"),M2:M4)

Hope this helps!

In article ,
Todd <Todd @discussions.microsoft.com wrote:

D I J M O <--column
How Type SP Bid Status <--Label
PM 21 AF 100 P
SC 41 AF 1000 L
CQ 11 DP 750 S

How do I get the sales totals for this? Count column D if it equals PM,
column I equals 21, and column O equals S, = sum column M. Please help.

How do I count letters and numbers in a formula?
 

Hi

Try this:

=SUMPRODUCT(--(D1:D10="PM"),--(I1:I10=21),--(O1:O10="S"),M1:M10)

Better to use cells to hold the criteria:

A1 = PM
A2 = 21
A3 = S

=SUMPRODUCT(--(D1:D10=A1),--(I1:I10=A2),--(O1:O10=A3),M1:M10)

Biff

"Todd" <Todd @discussions.microsoft.com wrote in message
...
D I J M O <--column
How Type SP Bid Status <--Label
PM 21 AF 100 P
SC 41 AF 1000 L
CQ 11 DP 750 S

How do I get the sales totals for this? Count column D if it equals PM,
column I equals 21, and column O equals S, = sum column M. Please help.

How do I count letters and numbers in a formula?
 

I had the parenthesis around the 21 --(I2:I4="21"). I see my mistake.
Thanks.

"Domenic" wrote:

Try...

=SUMPRODUCT(--(D2:D4="PM"),--(I2:I4=21),--(O2:O4="S"),M2:M4)

Hope this helps!

In article ,
Todd <Todd @discussions.microsoft.com wrote:

D I J M O <--column
How Type SP Bid Status <--Label
PM 21 AF 100 P
SC 41 AF 1000 L
CQ 11 DP 750 S

How do I get the sales totals for this? Count column D if it equals PM,
column I equals 21, and column O equals S, = sum column M. Please help.

How do I count letters and numbers in a formula?
 

I had the parenthesis around the 21 --(I2:I4="21"). I see my mistake.
Thanks.

"Biff" wrote:

Hi

Try this:

=SUMPRODUCT(--(D1:D10="PM"),--(I1:I10=21),--(O1:O10="S"),M1:M10)

Better to use cells to hold the criteria:

A1 = PM
A2 = 21
A3 = S

=SUMPRODUCT(--(D1:D10=A1),--(I1:I10=A2),--(O1:O10=A3),M1:M10)

Biff

"Todd" <Todd @discussions.microsoft.com wrote in message
...
D I J M O <--column
How Type SP Bid Status <--Label
PM 21 AF 100 P
SC 41 AF 1000 L
CQ 11 DP 750 S

How do I get the sales totals for this? Count column D if it equals PM,
column I equals 21, and column O equals S, = sum column M. Please help.