Count rows in all non blank cells in certain columns

Hello Friends

Please find the attached file (Count rows in all non blank cells in certain columns.xlsx).

If all the cells in the columns D:I is filled i.e., non blank (For better understanding I made a number 1 to 13 in Column B.) then it needs to be counted in light yellow cell K2.

thanks in advance.

Can you use a helper column? If so this gets much easier.

Try this...

=SUMPRODUCT(--(MMULT(--(D2:I146<>""),{1;1;1;1;1;1})=6))

Hello kvsrinivasamurthy and Biff

Thank you

Both of your formulas working well.

Thanks again

You're welcome. Thanks for the feedback!