Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique counting formula
Thanks to an earlier discussion I have been able to use the formula
=SUMPRODUCT((E2:E1000<"")/COUNTIF(E2:E1000,E2:E1000&"")) to count how many different numbers appear between cells E2 and E1000. Column E is house numbers. I would now like to be able to count how many entries in cells A2:A1000 are =1. Column A is the number of days that a repair is outstanding. The result would be the number of houses with a repair outstanding by 1 day or more. Can anyone make sense of what I have said and help? Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Values | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions |