sum total

[FreddyPetersen]

I am looking for a way to toal a simple sum totaled list.

3
3
6

4
4
8

14


the answer is 14, but how to get excel to caculate this?

thanks in advance for any help!

 

[hcj]

Hi Freddy,
Without more information, it looks like you're going to
have to do the grand total with an explicit formula.
Assuming your example starts in A1, and A3 and A7 are
subtotals of A1:A2, and A5:A6, and the grand total is in
A9, use =A3+A7 in cell A9.

If the values are (or could be) associated with labels of
some sort, then you might be able to use the
Data/Subtotals function.

Hope this helps a bit.

 

[Max]

Assuming your list is in A1:A7
with (sub)totals in A3 and A7

Try in say, A9: =SUM(A3,A7)