Hello,

I am trying to figure out how to count the numbers in a row based on the contents of another row. The contents of the second row consists of zeroes and ones; I want to count those cells in the first row which correspond to zeroes in the second. One laborious and impractical way to do this would be AND(B30>0 ;B41=0)+AND(C30>0;C41=0)+AND(D30>0;D41=0)+...+AND(DR30>0;DR41=0).

Is there a simpler way to accomplish this? I could of course create a new row with the AND statements and then sum it, but I would strongly prefer not to because I want to do this for many rows of data.

Thanks for any help!

Shane