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.
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.
Try...
=SUMPRODUCT(--(D2:D4="PM"),--(I2:I4=21),--(O2:O4="S"),M2:M4)
Hope this helps!
In article <[email protected]>,
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.
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
news:[email protected]...
> 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.
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 <[email protected]>,
> 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.
>
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
> news:[email protected]...
> > 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.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks