Sumif with 2 criteria

[Jhon Mustofa]

hello all,

i have over 100 set data and looking some sum formula with 2 criteria :

a-------6-------x1
b-------3-------x2
b-------2-------x2
b-------7-------x2
a-------6-------x1
c-------9-------x3
a-------10-------x1
c-------4-------x3
d-------7-------x4
etc....

how to sum data number not include/ignore x1 and x3

thanks!!

[Izandol]

You may use:
=SUMIFS(B1:B9,C1:C9,"<>x1",C1:C9,"<>x3")

[Debraj Roy]

Another approach..

Please Login or Register  to view this content.

=SUM(SUMIF(CriteriaRange,{"*","X1","X3"},SumRange)*{1,-1,-1})

[Jhon Mustofa]

Hi guys...it's helpful for me..

many thanks!!!