Thread
:
Averaging formula error
View Single Post
#
8
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Averaging formula error
Is it ByDay or By Day with a space?
--
Don Guillett
SalesAid Software
"Tammy" wrote in message
...
Hi - I don't have any #N/A in HI
=AVERAGE(IF(((ByDay!B1:B65000="LAZ")*(ByDay!AI1:AI 650000%)),ByDay!AI1:AI65000))
changed the column to AI anyway - I'm getting a #NAME? error
"pinmaster" wrote:
Hi,
Nothing wrong with the formula but I'm guessing you have some cells that
are
reporting a #N/A error in HI1:HI65000. Fix that and you should be ok.
=IF(ISERROR(your_formula),"",your_formula)
HTH
Jean-Guy
"Tammy" wrote:
Please tell me what's wrong with my formula.
=AVERAGE(IF(((ByDay!B1:B65000="LAZ")*(ByDay!HI1:HI 650000%)),ByDay!HI1:HI65000))
then I'm doing CSE
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett