CountIF question
 

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.

CountIF question
 

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.

CountIF question
 

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


On Apr 18, 3:09*am, "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,AD1*0)))

TIA
Mark.

CountIF question
 

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.

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

CountIF question
 

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

CountIF question
 

Thx everyone

Appreciate the input & help

Regards
Mark.