=SUMIFS(Transactions!$AI:$AI,Transactions!$A:$A,$E$3,Transactions!$D:$D,$B7)
This is the formula I am using and I want to have the formula work like this =SUMIFS(Transactions!$AI:$AI,Month(Transactions!$A:$A),$E$3,Transactions!$D:$D,$B7)
Where the criteria looks at the month so see if it matches the month in cell E3. Is there a way that I can make this work with another formula?
This is the formula I am using and I want to have the formula work like this =SUMIFS(Transactions!$AI:$AI,Month(Transactions!$A:$A),$E$3,Transactions!$D:$D,$B7)
Where the criteria looks at the month so see if it matches the month in cell E3. Is there a way that I can make this work with another formula?