Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct exclude count
=COUNTIF(A7:A11,"test")-SUM(COUNTIF(B7:B11,{"problem","solved"}))
"Dreamstar_1961" wrote: I'm trying to get somproduct to count every occurance of a word but except where they match another word. like below it would not count both "problem" and "solved" but would count every thing else, but it don't seem to be working, this is how I thought it be written =sumproduct((a7:a60="test")-(b7:b60={"problem","solved"})) given a result for below of 3, but that is not working as I seem to have a ghost of 1 coming up, a7 test b7problem a8 test b8 solved a9 test a10 test b10 resloved a11 test b11 next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) | Excel Worksheet Functions | |||
SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year) | Excel Worksheet Functions | |||
SUM, COUNT and SUMPRODUCT | Excel Worksheet Functions | |||
exclude data from count | Excel Worksheet Functions | |||
Count 350 SS numbers, exclude duplicates | Excel Discussion (Misc queries) |