Forum Discussion
Solved
Using Excel SUMIF with a condition and a Date Range
Hello, I'm aggregating data that rolls into my spreadsheet every two weeks. I keep the raw data on a secondary tab called "Form Responses." I'm currently using the formula below to parse through...
The formula you need in ResponseSummary!D2 of the attached file is:
=SUMIFS('Form Responses'!C:C,
'Form Responses'!A:A,">="&A2,
'Form Responses'!A:A,"<="&B2,
'Form Responses'!B:B,"*"&C2&"*")
