SUMIF

[Lennon]

I kind of need to do the opposite to a sumif.

e.g. =sumif(A:A,"Contra", E:E)

This would sum all in column E were column A contains the word contra.

I need to sum everything but the contra. Is this possible?

Thanks

 

[Domenic]

Try...

=SUMIF(A:A,"<>Contra",E:E)

Hope this helps!

 

[Lennon]

Thank you.

I really thought I'd already tried this but I think I put the <> before the speechmarks instead of inside them.

Sorry to trouble you again but can this also be used in a range i.e. sum everything excluding contra and another word?

 

[Domenic]

Try...

=SUM(E:E)-SUM(SUMIF(A:A,{"Contra","OtherWord"},E:E))

Hope this helps!

 

[jmckeone]

similar issue for which I need an answer

I'm looking to something somewhat similar ... do a COUNTIF if one or another text string is present.

 

[Aladin Akyurek]

Re: similar issue for which I need an answer

I'm looking to something somewhat similar ... do a COUNTIF if one or another text string is present.

=SUM(COUNTIF(A2:A100,{"X","Y"}))

would count the occurrences of the strings X and Y in A2:A100.