Monday, February 25, 2013

yogi_Compute Sum Of Amounts For A Specified Week Number Based On Whether Week Begins With Sunday Or Monday

                                          Google Spreadsheet   Post  #1044
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Feb 25, 2013
user Eduard Grama said:(!category-topic/docs/spreadsheets/ysegyRWPYJY)

I am currently using Excel 2013 Professional but I want to be able to use the same formula in a Google Spreadsheet. Basically, the formula I have in Excel is this:


Column U represents dates.
Cell H1 is the number of the week (1-53) and column AH is the amount invoiced. 
The formula returns me the sum of all invoices for the week number specified in cell H1. All other invoices that don't have a date within the week number specified in cell H1 are neglected. 

Thank you.

Thank you so much for your help Yogi.

in the following I have presented a solution to a bit more generalized problem