=SUMPRODUCT(--(A2:A2000=0),--(B2:B20000)

=SUMPRODUCT(--(A2:A2000=0),--(B2:B2000=0),--(C2:C200000)


"ronnomad" wrote:

Hello again.

I have a spreadsheet with 46 columns (will be 52) and (so far) 1600 rows.
The cells in each column and row contains a number equal to or greater than
zero. What I would like to do is;
1. count the number of cells in column 2 with a value 0, if the value in
column 1 in the same row is = 0.
2. for each subsequent column (i.e. column 3) count the number of cells with
a value 0, if the value in the previous columns (1 & 2) & corresponding rows
= 0.

Logic tells me it has got to be a combination of IF, AND & COUNTIF OR
SUMPRODUCT but I am not able to come up with the right solution.