Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello all
Need help Trying to use the sumproduct function to count multiple criteria where one column has text Example: Col. A Col. B 6 Yes, Hot, In 8 No, Cold, Out 6 No, Hot, Out 8 No, Cold, In I'm trying to count col. A if 8 is In Thanks for any sugestions! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count using multiple criteria including text strings | Excel Worksheet Functions | |||
CountIF for two columns with two criteria with text | Excel Discussion (Misc queries) | |||
COUNTIF with text criteria | Excel Worksheet Functions | |||
Mutiple COUNTIF or equivalent. | Excel Worksheet Functions | |||
Mutiple match criteria | Excel Discussion (Misc queries) |