Tuesday, July 2, 2013

yogi_Compute Total Amount By Weekday Based On Multiple Criteria

                                          Google Spreadsheet   Post  #1267
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 02, 2013
user Corporate Analyst (http://productforums.google.com/forum/?zx=aif3093lky7l#!category-topic/docs/spreadsheets/NdbQ7KNuTH4)
use a date format as a day of the week in if criteria
Hi,

I have a list of date, value,etc and on a separate sheet i have to add all the values for Mondays.

Thanks.
---
Dear YogiAnand

Thank you for your revert.

I have shared a link for a sheet. under that tab called Date Calculation. 


Also on another topic i'm trying to merge multiple documents(7Sheets) into one sheet. From the advise i got i have entered the formulas into the master Sheet. Can you see if I have done so correctly.

I really appreciate your advise
-------------------------------------------------------------------------------------------------------------------------------------------