CountIF question

[NoodNutt]

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.

 

[Gav123]

Hi Mark,

Maybe...

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

Hope this helps,

Gav.

 

[krcowen]

Mark

Highligh all the cells you are counting (use the control-left click to
highlight the discontinuous range). Then name the discontinuous range
e.g. "test" (Insert-Name-Define).

Then use this formula:

=counta(test)

Naming the range is a little messy, but, the formula is easy after you
have defined the name.

Goodl luck.

Ken
Norfolk, Va

 

[Dave]

Hi Gav,
Jumping in here, on a related issue:
COUNT and COUNTA can handle multiple ranges like the one below, but I
haven't managed to do that with COUNTIF. When I insert the comma to separate
each range, the function seems to see the following range as the condition
thingy.
Is it possible to use multiple ranges inside the COUNTIF function?
Dave.

 

[Dave]

Hi Ken,
Thanks! Why don't I think of these things?
Dave.

 

[NoodNutt]

Thx everyone

Appreciate the input & help

Regards
Mark.