Countblanks

  • Thread starter Thread starter scott63304
  • Start date Start date
S

scott63304

I need to countblanks in a column. But only for the rows
that have data in another column. I'm currently using the
countblanks function in the following way:
countblanks('sheet1!'b2,b200).
I would like to count blanks in column B when column A is
populated.

Thanks
Scott
 
thanks for the feedback.

Is there also a way to do this without the row references.
This worksheet currently has 100 row entries which will be
updated daily. I need someway to do the calculation below
without having to update the cell references. For example,
from 200 to 225.

Scott
 
Hi
SUMPRODUCT does not accept references like B:B. So one workaround: Make
the range quite large (if you don't have that many SUMPRODUCT
formulas). Another way would be to use a dynamic range. Something like
=SUMPRODUCT(--(OFFSET($A$1,0,0,COUNTA(A:A))<>""),--(OFFSET($B$1,0,0,COU
NTA(A:A))=""))
 
Back
Top