Tuesday, November 6, 2012

yogi_Compute Stats From Beginning Of Year To Specified Month For Multiple Criteria

                                           Google Spreadsheet   Post  #857
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 07, 2012
user kherbert said : (http://productforums.google.com/forum/?zx=xdgf04nj8c5p#!category-topic/docs/spreadsheets/XqpqVWQ0ZRs)
sumproduct formula evaluating text range 


I have a range of headings in columns A1 thru L1 labeled Jan thru Dec.  I have data under each A2 thru L2.  I need to calculate YTD numbers based on mult criteria depending on the month designated in another cell.  In other words, with the month of Sep designated, I need to sum the values for Jan:Sep or if Jun is designated, I need to sum the values for Jan:Jun.  I have tried all kinds of variations to the sumproduct formula, but it keeps giving me the full year total as the answer.  Please help!
Attachments (1)
15 KB   View   Download
following is a solution to the problem