| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| VLOOKUP for a cell with both letters and numbers | Excel Discussion (Misc queries) | |||
| Display numbers only, no text formula | Excel Worksheet Functions | |||
Linear Mode
