one thing
=SUMIF(C:C,"total",B:B)
or
x=application.SUMIF(C:C,"total",B:B)
msgbox x
--
Don Guillett
SalesAid Software

"s_u_resh" wrote in message
...

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 above
sum formulas)


How do i write in macro?

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

Please help .

Thanks
S.Suresh


--
s_u_resh
------------------------------------------------------------------------
s_u_resh's Profile:
http://www.excelforum.com/member.php...o&userid=15670
View this thread: http://www.excelforum.com/showthread...hreadid=272116