| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf or sumproduct
I need a countif or sumproduct formula that can count a number of values
based on a multiple criteria. Count range: D:D column Criteria: Count the number of cells that are greater than 0 and less than 200 in column H:H, that also have a the word "BUY" in coulmn B:B. Any help would be appreciated. -- Regards, timmulla |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT, COUNTIF and wildcard | Excel Worksheet Functions | |||
| sumproduct vs. countif | Excel Discussion (Misc queries) | |||
| countif more than one sheet/tab and sumproduct | Excel Worksheet Functions | |||
| countif, sumproduct | New Users to Excel | |||
| Using COUNTIF with 2 criteria - SUMPRODUCT? | Excel Worksheet Functions | |||
Threaded Mode
