Excel Guides

Using SUM in a Macro in Excel

You can use the SUM function in a macro in Excel by first selecting the cell or range of cells that you want to sum. Then, click on the "Formulas" tab and select "Function Library." Scroll down to the "Math & Trig" section and select "SUM."

In the "Number1" field, enter the cell or range of cells that you want to sum. If you want to sum multiple ranges, you can enter them in the "Number2" field. You can also add cells or ranges in the "Number3" and "Number4" fields.

Once you have entered all of the cells or ranges that you want to sum, click on the "OK" button. The SUM function will then calculate the sum of all of the cells or ranges that you selected.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.