I have several form responses sheets (that I ImportRange into a common workbook) that need to display a total every Monday through Friday of the week that updates for current week Monday - Friday. I thought it may be an ArrayFormula(SumIf....based on date range but I cannot figure it out. In addition to this...I then need to query those same Monday - Friday totals into a Summary sheet within this same workbook...but I think I have that part figured out for now.

Any help to figure this out would be greatly appreciated!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.