Forum home » Delegate support and help forum » Microsoft Excel Training and help » Index formula within a sum formula
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Index formula within a sum formula
Resolved · Medium Priority · Version 2007
Reply Tue 26 Jul 2011, 17:24Delegate Julie said...
Julie has attended:
Excel Advanced course
Index formula within a sum formula
Hi,
I am trying to write a formula which will sum my year to date figure.
Jan-11 Feb-11 Mar-11 Apr-11 and rest of year
100 20 50 100
So if for example it was now Mar and I just wanted one formula at the end column to sum Jan - mar how would I do this. I want to keep using the same spreadsheet each month.
Many thanks
Julie
For upcoming training course dates see: Pricing & availability
RE: 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
Wed 3 Aug 2011: Automatically marked as resolved.
|