activematx

asked on

# Excel Macro to put a simple SUM formula down cells

Hi Excel Experts,

Take a look at this image here:

I need a macro which can put a sum formula into

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

Take a look at this image here:

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.