Insert formulas & copy them to variable size rows and columns

I have being struggling with this over 4 hrs. Could you please help me?

In "D3" I would need:
1) Sum the values of the range "E3" to the last column to the right. The number of accounts changes every month.
2) Copy the formula down to the last row (the last row changes every month)

In “E3” I would need:
1) Type in the formula that is in “E3”
2) Copy that formula to the last row and last column (the last row and column varies month over month)

Thank you in advance for your assistance,
DPP

Which version of Excel do you have?
You attached an .xls file which is 2003 or before.
SUMIFS is not available in 2003. You can use SUMPRODUCT but that does not accept whole columns (like "A:A")
If you have 2007 or later, you can try this.

Please Login or Register  to view this content.

Hi Jolivanes,

I have Excel 2010. I would really aprreciate your help :O)

I am new to macros and I am still struggling with this workbook.

Thank you,
DPP