Wednesday, January 1, 2014

yogi_MultiConditional Sum Using SUMIFS Function In Google New Sheets

                                          Google Spreadsheet   Post  #1461
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-01-2014
question by Mark Tice (http://productforums.google.com/forum/?zx=f1190urkz7zs#!category-topic/docs/spreadsheets/wmC9Z4l0-7s)
How can I sum values in one column (column D) based on a date range criteria in another column (A)?
How can I sum values in one column (column D) based on a date range criteria in another column (A)?

In Microsoft Excel with the sumifs function the initial formula looks like this: =SUMIFS(D:D,A:A,">8/25/2013",A:A,"<9/1/2013")

Once I figure that out I need to figure out how I can apply it to one page at the end of a 30 page workbook to count the same columns based on the same date range in every sheet in the workbook.

Any ideas or advice would be greatly appreciated!

Thanks,

Mark
------------------------------------------------------------------------------------------------------------------------------------------------------
I didn't see any problem with the formula you have delineated ... in any event have a look at the illustrative solution I have presented using various alternate formulations


No comments:

Post a Comment