Forum Discussion
Solved
need help with excel formula
Hi there. I am trying to move over info from one sheet to another using =sumif or =sumifs. This is for budgeting. I input the receipt into the first sheet and I want it to automatically add to the ne...
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))
.png){kind=link}
.png){kind=link}
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. 🙂