Hi Mark,

Maybe...

=COUNTA(B8:B11,I7,I9:I11,P7,P8,P10,P11,W7:W9,W11,A D7,AD8,AD9,AD10)

Hope this helps,

Gav.

"NoodNutt" wrote:

Hi all

Can anyone help with the correct syntax for tha following please.

I need the formula to count all the cells in this exact range that are not
blank.


=countif(not(blank(B8:B11,I7,I9:I11,P7,P8,P10,P11, W7:W9,W11,AD7,AD8,AD9,AD10)))

TIA
Mark.