sumifs excluding multiple criteria

[Portug]

Hi there need some help
i am trying to write a formula to add all the values but i need to exclude two criteria
this formula i used to exclude one criteria but now i need to add another and i cant seam to make it work
( =SUMIFS(F2:F9,E2:E9,"<>Voucher" )

i have tried using [ SUMIFS(F2:F9,E2:E9,{"<>Voucher", "<>Christmas Voucher Redeemed"}) ], but no luck it dosent work

this is what i am trying to add, but i want to keep (Voucher and Christmas Voucher Redeemed)

any help would be much appreciated thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about

SUMIFS(F2:F9,E2:E9,"<>Voucher",E2:E9, "<>Christmas Voucher Redeemed")

 

[Portug]

Hi & welcome to MrExcel.
How about

SUMIFS(F2:F9,E2:E9,"<>Voucher",E2:E9, "<>Christmas Voucher Redeemed")

Hi MrExcel
Thanks for the help problem solved. it works fine as you mentioned

 

[Fluff]

You're welcome & thanks for the feedback.