countblank with range

[lezawang]

Hi
I have 3 ranges like below. I named A1:A5 as myrange1, C1:C3 as myrange2, E1:E2 as myrange3.
Then I highlight A1:A5, C1:C3, and E1:E2 (user CTRL) and then named them as "ALL"

When I do
= countblank(myrange1), I get 2

When I do
=countblank(ALL), I got #value

Why is that? Thank you so much.

10		1		400
20		2		500
		3
100

<tbody>
</tbody>

 

[oldbrewer]

even though you highlight all 3 ranges and name it, excel does not accept it - I named them myrange 4 but when you highlight them the name does not appear where eg range 1 does

 

[Fluff]

Looks like countblank, will not except non-contiguous ranges

 

[oldbrewer]

so use countblank(range1) + countblank(range2) etc