Formula problem

  • Thread starter Thread starter Len
  • Start date Start date
L

Len

Hi,

After several attempts, it fails to show the correct result for the
following formula

Extract of vba code

Cells(s, 3).Formula = "=SUM(" & Range(Cells(s, 3).Offset(-1, 0), _
Cells(s, 3).End(xlUp)).Address(False, False) & ")" & "-
SUMIF(C[-2],""CF Total"",C)"

Any idea ?

thanks in advance

Regards
Len
 
Hi Joel,

Thanks for your reply and your codes.

It works perfectly !

One more question, how to modify your codes so that this formula
becomes variable formula which can be copied and paste to next 12
columns at the same row so that it can sum up the 12 months with Total
tabulation ?

Thanks again

Regards
Len
 
Hi Joel,

Thanks for your great help!

Your codes on formula with Address property is very useful and need to
work around

Regards
Len
 
Back
Top