Forum Discussion
need help with excel formula
Make sure that all the ranges that you refer to are from row 2 to row 125.
 
=SUMIFS('Form Responses ''21'!$D$2:$D$125, 'Form Responses ''21'!$E$2:$E$125, Q$1, 'Form Responses ''21'!$B$2:$B$125, ">="&$A2, 'Form Responses ''21'!$B$2:$B$125, "<="&EOMONTH($A2, 0))
In A2 on the Totals sheet, enter the date 01/01/2021, and in A3, enter 02/01/2021.
Apply the custom format mmmm to these cells, so that they display the full month name.
Select A2:A3, then fill down to A13.
Enter the following formula in Q2:
=SUMIFS('Form Responses ''21'!$D$2:$D$125,' Form Responses ''21'!$E$2:$E$125, Q$1, 'Form Responses ''21'!$B$2:$B$125, ">="&$A2, 'Form Responses ''21'!$B$2:$B$125, "<="&EOMONTH($A2, 0))
This can be filled down, but also to the left and right.
- Thank you for replying and helping. I was able to change the information on the totals sheet as you instructed... but when I inputted the formula in Q2 I received this - #VALUE! Array arguments to SUMIFS are of different size.
Make sure that all the ranges that you refer to are from row 2 to row 125.
 
=SUMIFS('Form Responses ''21'!$D$2:$D$125, 'Form Responses ''21'!$E$2:$E$125, Q$1, 'Form Responses ''21'!$B$2:$B$125, ">="&$A2, 'Form Responses ''21'!$B$2:$B$125, "<="&EOMONTH($A2, 0))
- It worked!! And I was able to apply it to all the cells!! Thank you so much for your help. I greatly appreciate it. 🙂
.png){kind=link}
.png){kind=link}