Counting blank cells

Hi there,

I am trying to create a formula that will count blank cells within one colunm but not in a line. I have the below already, but need to add D40-D45 etc etc

=COUNTBLANK(Planner!D11:D18)

I hope this makes sense, I hope someone can help

Thanks

It seems like "COUNTBLANK" needs a contiguous area to work it's magic so you need to add the different areas i.e.

Please Login or Register  to view this content.

Alf

Try this =COUNTBLANK(D11:D18)

Thanks Alf - But that still doesnt seem to work?!

Hi Sathikm - that is fine however I then need to add another few lines further down the column eg D44:-D48

Any ideas?

Thansk Pepe but i need it to count Specific cell ranges, not all blank cells

Pepe, tried the below as need to take the info from 1 tab and place in another

=SUMPRODUCT(Planner!D11:D18,Planner!D40:D45,Planner!D68)

Again didnt work

Cracked it thanks

Thanks Alf - But that still doesnt seem to work?!

Sorry, my bad should be

Please Login or Register  to view this content.

One "(" to much in formula.

Alf