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.
"FSt1" wrote:

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" wrote:

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?