Sunday, May 27, 2012

yogi_Compute Sum Of Entries In A Column For The Last Specified Number Of Days

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #564    May 27, 2012     www.energyefficientbuild.com.

Based on a post by Adam ...
http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/LEYuTOmGLhw
I have created the following illustration

Posted by at
Labels: , , , , ,

2 comments:

  1. N PJune 2, 2012 at 8:34 AM

    Yogia, how would this work if one were trying to get the last 20 entries from the Date column?

    ReplyDelete
  2. Yogi AnandJune 2, 2012 at 9:56 AM

    Hi NP:

    Let me see if I understood you correctly -- try

    =filter(A2:A,row(A2:A)>=count(A2:A)-20+2)
    if the dates are in range A2:A, the formula will extract the last 20 date entries
    in range A2:A

    is this what you are looking for?


    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete

Subscribe to: Post Comments (Atom)