SUMIF question

[Lynne]

How can I SUM amounts in Column C where the text in
Column A is not equal to a certain text string?

Thanks for any help!

 

[Frank Kabel]

Hi
=SUMIF(A1:A100,"<>text",C1:C100)

 

[JE McGimpsey]

One way:

=SUMIF(A:A,"<>certain text string",C:C)

 

[Lynne]

Thank you so much! I didn't know about <>.