Index formula within a sum formula

Hello Julie,

Thank you for your question regarding sum.

From your question, I would think you could achieve what you ask very easily.
If you have for example all your dates sales values, Jan, Feb, March across a row e.g. A1:L1, and you need the total in M1, then simply have in cell M1 =sum(A1:L1)
This will add up all the 12 month values, but only the ones currently typed in, e.g. you have figures in the first 4 months, it will add those, but as soon as you add a figure in the next month, the total will update.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer