sum and count nonadjacent cells

[Guest]

Hi everyone
Let's suppose a1,a5,a8 equals 3,5 and 9 and it's named abc
Let's suppose a2,a6,a9 equals 2,6 and 8 and it's named def
In another cell, let's say, a3 i input abc and on a4 and a5 it shows me the
count and the sum of that range name. Waht is the formula? I've tried
Sum(indirect(a4)) and it didn't work. Any ideas?
Tks in advance
Pedro

 

[Frank Kabel]

Hi
your formula should work. What does it return. Also check that the
names are exactly identical

 

[Dave Peterson]

What happens when you use that formula?

If you get 0, then your cells aren't really numbers--they're text that looks
like numbers.

Format those cells (a1,a5,a8, a2,a6,a9) as general and reenter the values
(F2 followed by Enter is enough--but all the cells).