sum and count nonadjacent cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi
your formula should work. What does it return. Also check that the
names are exactly identical
 
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).
 
Back
Top