Link to home
Start Free TrialLog in
Avatar of activematx
activematxFlag for United States of America

asked on

Excel Macro to put a simple SUM formula down cells

Hi Excel Experts,

Take a look at this image here:  User generated image
I need a macro which can put a sum formula into Column N that sums up the numbers in Column M.

I already have the sum formula in cell N32 that I entered in manually.  Inside of the above screenshot you have the formula that I would like to have inside of cell N37 being displayed.

I have highlighted the cells yellow in the screenshot where I want the formula to go.  The purple cell which has zero, does not matter (the formula can go here, or you can tell the macro to skip ones with zero).

Thank you so much for helping me with this problem.  I have attached the workbook to this question as well.
FY12-Invoices-EE.xlsx
SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial