Auto Sum formula - how to write in Macro

[s_u_resh]

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

 

[Don Guillett]

one thing
=SUMIF(C:C,"total",B:B)
or
x=application.SUMIF(C:C,"total",B:B)
msgbox x