Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double count
I have the following data:
w 1 w 1 w 2 w 1 w 1 c 3 w 2 c 1 c 1 w 3 c 1 I need a formula that calculates how many of the w's have numbers greater than 1. I was trying this formula: sumproduct(--(C2:C12="W"),--(D2:D121)) but it doesn't work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Double Count | Excel Discussion (Misc queries) | |||
count double occurences | Excel Worksheet Functions | |||
Double lookup count | Excel Worksheet Functions | |||
count data but avoid double entries | Excel Worksheet Functions |