Multiple Criteria - One Range

I have read multiple forums and threads about this but I am still confused. I am trying to use an averageifs statement to get the average call for everything that was not from a certain caller ID.

For instance, I want the average "Duration MM:SS" for all rows NOT containing caller ID "CallerID1"


Any help is greatly appreciated.


Attached is a sample excel doc.

This can do it:

=AVERAGEIF(C2:C5,"<>"&"CallerID1",I2:I5)

• <> translates to: not equal to

Awesome! What exactly does the "<>" part do here? Trying to wrap my head around this.

AVERAGEIF(C2:C5,"<>"&"CallerID1",I2:I5)

The <> means ≠ or not equal.

The operator is in quotes to separate the condition from trying to literally search cells in the range for "<>CallerID1"