Quote Originally Posted by Bob Phillips View Post
Try this array formula

=SUM(--(FREQUENCY(IF(($B$2:$B$1000=$M$4)*($D$2:$D$1000=$K$5)*($H$2:$H$1000=$L5),MATCH($I$2:$I$1000,$I$2:$I$1000,0)),ROW(INDIRECT("1:"&ROWS($I$2:$I$1000))))>0))
Hi Bob
I'd like to ask a question that deals with counting blanks, instead of summing. I have column of data and I am counting the blank cells by using Countblank(A1:A101). Next month I will have more rows of data, say 200 rows and I'd like my formula to count the blanks to the last non-blank value in the column. Is there a way to do that in a formula instead of VB?
Thanks
Joe (new member to list)