| 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 | |||
Hybrid Mode
