CountIF question


N

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.
 
Ad

Advertisements

G

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.
 
K

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
 
D

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.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top