Sumifs with "does not equal"

[sburkhar]

I'm attempting to sum column P:P with the following criteria"
A:A = DS
J:J Contains "Board"
AA:AA does not equal "Invoiced"

My Sumifs formula is working up until the "does not equal" part is added in. I'm not sure where "does not equal" needs to be placed. So below is as far as I can get:

=SUMIFS(Tracking!P:P,Tracking!A:A,"DS",Tracking!J:J,"*Board*"



Excel 2016

Thank you!
Sharon

 

[Bo_Ry]

Please try
=SUMIFS(Tracking!P:P,Tracking!A:A,"DS",Tracking!J:J,"*Board*",Tracking!AA:AA,"<>Invoiced")

 

[sburkhar]

That worked! thank you. I was putting my quotation marks in the wrong spot.