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)?
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