Hi, I am tying to do a sumifs formula that
=Sumifs('sheet2'!$A$5 :$A$20,'sheet2'!$B$5:$B$20,Left($B9,4),'sheet2'!$C$5:$C$20,">59",'sheet2'!$C$5:$C$20,"<199",'sheet2'!$D$5:$D$20,'sheet3'!$C$11)*-1
It is not returning the right totals.
I need sheet 2 column a to sum if:
The 4 digits on sheet 2 in column b match the left 4 digits of reference cell on results page cell b9
Account reference numbers on sheet 2 column c are between 59 and 1999
And
If the period number column d on sheet 2 matches the number in cell C11 on sheet 3
Please troubleshoot my formula so I can fix. Thank you!
Bookmarks