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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - need formula to count non-zero items in an array based on a vlooku (https://www.excelbanter.com/excel-worksheet-functions/202900-need-formula-count-non-zero-items-array-based-vlooku.html)

BKP

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?

FSt1

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

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?

BKP

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

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?

All times are GMT +1. The time now is 05:02 PM.