need formula to count non-zero items in an array based on a vlooku

[BKP]

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?

 

[FSt1]

hi
really not sure what it is you are trying to count but see if this works for
you
=countif(B2:B1,">0")

Regards
FSt1

 

[BKP]

Thanks, I found what I was looking for in the EXCEL MISC Section. The count
needed to be determined by a variable date range. I didn't need a VLOOKUP
after all.