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
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