Sum/Count Formula Help
Posted by Kim B on October 23, 2000 11:33 AM
I need a formula that will evaluate data in two different columns then count the occurences when both criteria are met. Column S contains numbers and column T contains text (names). I tried the array formula =SUM(S:S>0)*(T:T="name"), but get the error message #num!. If I don't use Control-Shift-Enter, I get either 0 or 1 as the result, not the total.
Thanks in advance for any help.