Thursday, November 27, 2014

yogi_Set Up Formula To Sum Up Numbers From A Starting Date To A Specified Date Larger Than Starting Date

              Google Spreadsheet   Post  #1848
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Nov-27-2014
post by  Antony Trimikliniotis:!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.


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

YTDFY 2014-15FY 2014-15Aug-14Sep-14Oct-14Nov-14Dec-14Jan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15
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)
Copy of ACT - SAM L 2014-10.gsheet
221 B   View   Download