=SUMIFS Function - mutliple criteria

[tdsmith14]

I'm needing a little help in figuring out how to add a criteria for the formula below. Currently the formula is pulling totals I need for items that are labeled as "CAT", but now I also need items that are labeled as "Commercial" in the same column D from the Invoice Tracker Detail (....,'Invoice Tracker Detail'!$D:$D,"CAT")

Or if it's easier then I just need to know how to exclude items labeled as "UW-CL", rather than having the formula looking for multiple items (CAT and Commericial).

I've tried researching other posts but none of them give me straightforward way of how to go about this.

=SUMIFS('Invoice Tracker Detail'!$L:$L,'Invoice Tracker Detail'!$B:$B,$A$3,'Invoice Tracker Detail'!$T:$T,">"&DATE(G$1-1,12,31),'Invoice Tracker Detail'!$T:$T,"<"&DATE(G$1+1,1,1),'Invoice Tracker Detail'!$E:$E,$A10,'Invoice Tracker Detail'!$D:$D,"CAT")+GETPIVOTDATA("CHECK AMOUNT",ALAE!$A$3,"VENDOR NAME","MASON CATASTROPHE CLAIM SERVICES","CHECK YEAR",2013)

[Jonmo1]

(....,'Invoice Tracker Detail'!$D:$D,"CAT")

Or if it's easier then I just need to know how to exclude items labeled as "UW-CL", rather than having the formula looking for multiple items (CAT and Commericial).

To exclude items labeled as "UW-CL", try

(....,'Invoice Tracker Detail'!$D:$D,"<>UW-CL")

[tdsmith14]

It worked. Thanks a bunch

[tdsmith14]

Out of curiosity if I wanted to just add multiple criteria as mentioned in the first half of my question by adding CAT and Commercial items to the formula how would I have done that?

[tdsmith14]

Below is what I was trying before, but didn't work.

=SUMIFS('Invoice Tracker Detail'!$L:$L,'Invoice Tracker Detail'!$B:$B,$A$3,'Invoice Tracker Detail'!$T:$T,">"&DATE(G$1-1,12,31),'Invoice Tracker Detail'!$T:$T,"<"&DATE(G$1+1,1,1),'Invoice Tracker Detail'!$E:$E,$A10,'Invoice Tracker Detail'!$D:$D,{"CAT","Comercial"})+GETPIVOTDATA("CHECK AMOUNT",ALAE!$A$3,"VENDOR NAME","MASON CATASTROPHE CLAIM SERVICES","CHECK YEAR",2013)

[Jonmo1]

That's close, put the whole sumifs formula inside a sum function..

=SUM(SUMIFS(........,'Invoice Tracker Detail'!$D:$D,{"CAT","Comercial"},........))

[tdsmith14]

O ok, understood. Thanks again.

[Jonmo1]

You're welcome.