need formula to count non-zero items in an array based on a vlooku
I would like to count the number of #'s 0 from B$2:cell(vlookup(A1,A2:B7,2)
A B
1 Sep-4
2 Sep-1 10
3 Sep-2 0
4 Sep-3
5 Sep-4 5
6 Sep-5 12
7 Sep-6
The cell/vlookup combo doesn't seem to work. Any suggestions?
|