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.
|