Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help Using COUNT or SUM/IF???
I want to be able to return a count where the cell in columns J and M are
both "X". Example: Colums J through M are cars andColumns N through O are the repairs. I want to be able to count by car, how many times for each repair. So I would need a total number of occurences where columns J and N are both equal to "X" I hope this makes sense. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help Using COUNT or SUM/IF???
try
=sumproduct((carrng="carA")*(jrng="x")*(nrng="x")) -- Don Guillett SalesAid Software "chickalina" wrote in message ... I want to be able to return a count where the cell in columns J and M are both "X". Example: Colums J through M are cars andColumns N through O are the repairs. I want to be able to count by car, how many times for each repair. So I would need a total number of occurences where columns J and N are both equal to "X" I hope this makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals by count | Excel Discussion (Misc queries) | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |