software

D I J M O lt;--column
How Type SP Bid Status lt;--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.

Try...

=SUMPRODUCT(--(D24=quot;PMquot;),--(I2:I4=21),--(O2:O4=quot;Squot;),M2:M4)

Hope this helps!

In article gt;,
Todd lt;Todd @discussions.microsoft.comgt; wrote:

gt; D I J M O lt;--column
gt; How Type SP Bid Status lt;--Label
gt; PM 21 AF 100 P
gt; SC 41 AF 1000 L
gt; CQ 11 DP 750 S
gt;
gt; How do I get the sales totals for this? Count column D if it equals PM,
gt; column I equals 21, and column O equals S, = sum column M. Please help.

Hi

Try this:

=SUMPRODUCT(--(D110=quot;PMquot;),--(I1:I10=21),--(O1:O10=quot;Squot;),M1:M10)

Better to use cells to hold the criteria:

A1 = PM
A2 = 21
A3 = S

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

Biff

quot;Toddquot; lt;Todd @discussions.microsoft.comgt; wrote in message
...
gt; D I J M O lt;--column
gt; How Type SP Bid Status lt;--Label
gt; PM 21 AF 100 P
gt; SC 41 AF 1000 L
gt; CQ 11 DP 750 S
gt;
gt; How do I get the sales totals for this? Count column D if it equals PM,
gt; column I equals 21, and column O equals S, = sum column M. Please help.
I had the parenthesis around the 21 --(I2:I4=quot;21quot;). I see my mistake.
Thanks.

quot;Domenicquot; wrote:

gt; Try...
gt;
gt; =SUMPRODUCT(--(D24=quot;PMquot;),--(I2:I4=21),--(O2:O4=quot;Squot;),M2:M4)
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; Todd lt;Todd @discussions.microsoft.comgt; wrote:
gt;
gt; gt; D I J M O lt;--column
gt; gt; How Type SP Bid Status lt;--Label
gt; gt; PM 21 AF 100 P
gt; gt; SC 41 AF 1000 L
gt; gt; CQ 11 DP 750 S
gt; gt;
gt; gt; How do I get the sales totals for this? Count column D if it equals PM,
gt; gt; column I equals 21, and column O equals S, = sum column M. Please help.
gt;

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

quot;Biffquot; wrote:

gt; Hi
gt;
gt; Try this:
gt;
gt; =SUMPRODUCT(--(D110=quot;PMquot;),--(I1:I10=21),--(O1:O10=quot;Squot;),M1:M10)
gt;
gt; Better to use cells to hold the criteria:
gt;
gt; A1 = PM
gt; A2 = 21
gt; A3 = S
gt;
gt; =SUMPRODUCT(--(D110=A1),--(I1:I10=A2),--(O1:O10=A3),M1:M10)
gt;
gt; Biff
gt;
gt; quot;Toddquot; lt;Todd @discussions.microsoft.comgt; wrote in message
gt; ...
gt; gt; D I J M O lt;--column
gt; gt; How Type SP Bid Status lt;--Label
gt; gt; PM 21 AF 100 P
gt; gt; SC 41 AF 1000 L
gt; gt; CQ 11 DP 750 S
gt; gt;
gt; gt; How do I get the sales totals for this? Count column D if it equals PM,
gt; gt; column I equals 21, and column O equals S, = sum column M. Please help.
gt;
gt;
gt;