Hi,

i want to know how to use the sum formula for the following example.



B

5
6
3
12
---
26 TOTAL
---
6
7
8
1
2
---
24 TOTAL
---

=26+24 ' TOTAL USING ALT + = SIGN or Auto Sum

( when i use the ALT + = SIGN or Auto Sum i get the total of abov
sum formulas)


How do i write in macro?

I do not want to make total and devide by 2.

Please help .

Thanks
S.Sures

--
s_u_res
-----------------------------------------------------------------------
s_u_resh's Profile: http://www.excelforum.com/member.php...fo&userid=1567
View this thread: http://www.excelforum.com/showthread.php?threadid=27211