3 Excel Formulas for Sum Calculation

Job ID: 38339481

Budget: $30 – $250 USD

I need 3 specific Excel formula created that will calculate the sum of the last 6, 12 and 18 cells in a given range (D14:O19). It should sum up the cells by moving upward column-wise and not to the left. This should be a dynamic formula that moves along as new data is entered. I don't want to use helper cells, so preferably in VBA.

The task at hand requires creating a formula that:

- Targets cells D14:O19.
- Calculates the sum of the last 6, 12 and 18 cells in this range.

The ideal candidate should have:

- Strong proficiency in Excel.
- Prior experience in creating complex formulas.
- Excellent problem-solving skills.