| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to combine SUMPRODUCT with COUNTIF?
Greetings,
I need to count up the number of occurrences of the letter "Q" in Column A, only if the string in Column B = "Claims." That is, how do I combine . . . =SUMPRODUCT(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,"Q",""))) AND =COUNTIF(B1:B100,"Claims") I have tried various approaches and different formulas, but nothing seems to work. Any help at all would be appreciated. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine SUMIF and SUMPRODUCT | Excel Worksheet Functions | |||
| Combine COUNTIF & EXACT | Excel Discussion (Misc queries) | |||
| Do I need to combine hlookup and countif????? | Excel Worksheet Functions | |||
| How do I combine 2 COUNTIF formulas?? | Excel Worksheet Functions | |||
| SUMPRODUCT - How to combine | Excel Worksheet Functions | |||
Threaded Mode
