Help on SUMIFS Funcrion Please

[JCarollo765]

I want to total more criteria than just RF at the end of the function, I want to add Interest, QF Fees etc.


=-SUM(SUMIFS(Data!$P:$P,Data!$L:$L,{"ACH ","Lbox Auto ","Cred Card ","Check ","Reappl Pmt"},Data!M:M,"RF "))

Is there a way to add multiple fields at the end? Thank you!

[Tony Valko]

Try this...

=-SUM(SUMIFS(Data!$P:$P,Data!$L:$L,{"ACH ","Lbox Auto ","Cred Card ","Check ","Reappl Pmt"},Data!M:M,{"RF ";"Interest";"QF Fees"}))

The SUMIFS function will accept up to 2 array constants. They must be entered in opposite directions, one horizontal and the other vertical.

Your 1st array is horizontal by use of comma delimiters and the 2nd array is vertical by use of semi-colon delimiters