Google Spreadsheet Post #1848
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov-27-2014
post by Antony Trimikliniotis:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!mydiscussions/docs/zZalvF63xPk
how to sum a range using OFFSET
---
The content of this email (and any attachment) is confidential. It may also be legally privileged or otherwise protected from disclosure.
This email should not be used by anyone who is not an original intended recipient, nor may it be copied or disclosed to anyone who is not an original intended recipient.
If you have received this email by mistake please notify us by emailing the sender, and then delete the email and any copies from your system.
All views and opinions expressed in this electronic message and its attachments are those of the sender and do not necessarily reflect the views and opinions of SAM Learning Ltd.
SAM Learning Ltd Registered in England No 2826785 Registered Office Webber House, 26-28 Market Street, Altrincham, Cheshire WA14 1PF
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!mydiscussions/docs/zZalvF63xPk
how to sum a range using OFFSET
Below is a formula that works well in excel but returns a parse error on google sheets.
=IFERROR(SUM(E11:OFFSET(E11,0,
the data looks like this with the YTD being column B and Jul-15 column P. The aim of the formula is to try and sum from aug to oct(E:G) and then next month aug to nov(E:H) etc
| YTD | FY 2014-15 | FY 2014-15 | Aug-14 | Sep-14 | Oct-14 | Nov-14 | Dec-14 | Jan-15 | Feb-15 | Mar-15 | Apr-15 | May-15 | Jun-15 | Jul-15 |
| Oct-14 | No. | No. | No. | No. | No. | No. | No. | No. | No. | No. | No. | No. | No. | |
| 2.0 | 2.00 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | |
| £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | |
| #ERROR! | 68 | 68 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
i have attached the file
the result in column B ,rather than returning an error, should sum columns e:G whenever I update the date in cell b5
The content of this email (and any attachment) is confidential. It may also be legally privileged or otherwise protected from disclosure.
This email should not be used by anyone who is not an original intended recipient, nor may it be copied or disclosed to anyone who is not an original intended recipient.
If you have received this email by mistake please notify us by emailing the sender, and then delete the email and any copies from your system.
All views and opinions expressed in this electronic message and its attachments are those of the sender and do not necessarily reflect the views and opinions of SAM Learning Ltd.
SAM Learning Ltd Registered in England No 2826785 Registered Office Webber House, 26-28 Market Street, Altrincham, Cheshire WA14 1PF
Attachments (1)
No comments:
Post a Comment