| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AVERAGE IF formula and not equal to ZERO
I'm looking for a formula similar to the following....but one that works.
=average(if((a1:a4="jones")+(C1:C4"0"),c1:c4)) Column A represents the sales rep column, C represents the percentage column. I want the average of the sales rep Jones without including those cells in C that are blank. I've tried control shift enter but something must be wrong with my formula because the zeros are still included. Thank you -- Lori |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
AVERAGE IF formula and not equal to ZERO
try this with CSE
=AVERAGE(IF((A1:A4="jones")*(C1:C40),C1:C4)) -- Don Guillett SalesAid Software "Lori Hornick" wrote in message ... I'm looking for a formula similar to the following....but one that works. =average(if((a1:a4="jones")+(C1:C4"0"),c1:c4)) Column A represents the sales rep column, C represents the percentage column. I want the average of the sales rep Jones without including those cells in C that are blank. I've tried control shift enter but something must be wrong with my formula because the zeros are still included. Thank you -- Lori |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| Value/IsNumber/Brackets..? cell equal to range w/o Average | Excel Discussion (Misc queries) | |||
| formula result #value! needs to equal zero for average calculation | Excel Worksheet Functions | |||
Linear Mode
