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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]10[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]400[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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