Sumproduct Average

[heater]

I want to look at column B and average column L, if column B DOES NOT equal
"TX". This formula works if column B equals "TX"

=SUMIF(B13:B100,"TX",L13:L100)/COUNTIF(B13:B100,"TX")

What is a formula if column B DOES NOT equal "TX"

 

[Toppers]

=SUMIF(B13:B100,"<>TX",L13:L100)/COUNTIF(B13:B100,"<>TX")

 

[Michael]

Hi heater. to sumif column B not equalling tx, use "<>tx" in your formula.
HTH