Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Average
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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Average
=SUMIF(B13:B100,"<TX",L13:L100)/COUNTIF(B13:B100,"<TX")
"heater" wrote: 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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Average
Hi heater. to sumif column B not equalling tx, use "<tx" in your formula.
HTH -- Sincerely, Michael Colvin "heater" wrote: 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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling average | Excel Worksheet Functions | |||
sumproduct & average | Excel Worksheet Functions | |||
Need to bring back Average using either Sumproduct or CSE formula | Excel Discussion (Misc queries) | |||
What is this kind of average called? | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |