| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT
I am trying to create a formula to count the number of text entries in that
match two criteria. This is as far as I have been able to go. Both fields are text. =SUMPRODUCT('Main'!A1:A1884<"")*('Main'!C1:C1884= "STHHH") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT
Think you were just missing the outer parens:
=SUMPRODUCT((Main!A1:A1884<"")*(Main!C1:C1884="ST HHH")) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Iriemon" wrote: I am trying to create a formula to count the number of text entries in that match two criteria. This is as far as I have been able to go. Both fields are text. =SUMPRODUCT('Main'!A1:A1884<"")*('Main'!C1:C1884= "STHHH") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT
DUH! What can I say, it's Friday and the brain is already on the weekend.
Thanks for the quick response. "Max" wrote: Think you were just missing the outer parens: =SUMPRODUCT((Main!A1:A1884<"")*(Main!C1:C1884="ST HHH")) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Iriemon" wrote: I am trying to create a formula to count the number of text entries in that match two criteria. This is as far as I have been able to go. Both fields are text. =SUMPRODUCT('Main'!A1:A1884<"")*('Main'!C1:C1884= "STHHH") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT
welcome. it happens to me too <g.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Iriemon" wrote in message ... DUH! What can I say, it's Friday and the brain is already on the weekend. Thanks for the quick response. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT
Try:
=SUMPRODUCT(('Main'!A1:A1884<"")*('Main'!C1:C1884 ="STHHH")) or the somewhat more efficient =SUMPRODUCT(--('Main'!A1:A1884<""),--('Main'!C1:C1884="STHHH")) In article , Iriemon wrote: I am trying to create a formula to count the number of text entries in that match two criteria. This is as far as I have been able to go. Both fields are text. =SUMPRODUCT('Main'!A1:A1884<"")*('Main'!C1:C1884= "STHHH") |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT
An extra pair of parenthesis should do it
=SUMPRODUCT((Main!A1:A1884<"")*(Main!C1:C1884="ST HHH")) Mike Mike "Iriemon" wrote: I am trying to create a formula to count the number of text entries in that match two criteria. This is as far as I have been able to go. Both fields are text. =SUMPRODUCT('Main'!A1:A1884<"")*('Main'!C1:C1884= "STHHH") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT | Excel Worksheet Functions | |||
| Sumproduct | Excel Discussion (Misc queries) | |||
| Sumproduct | Excel Discussion (Misc queries) | |||
| sumproduct | Excel Worksheet Functions | |||
| Sumproduct................. | Excel Worksheet Functions | |||
Hybrid Mode
