Thread
:
AVERAGE IF formula and not equal to ZERO
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
AVERAGE IF formula and not equal to ZERO
I now see that you also got answers in .misc. PLEASE do not post in more
than ONE group.
--
Don Guillett
SalesAid Software
"Don Guillett" wrote in message
...
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 With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]