Averaging formula error
....or you have #NAME? errors somewhere within your data....
...or you misspell one of the function names.....
But I was basing my determination on this:
Hi - I don't have any #N/A in HI
I think if they had #NAME? errors in the range they would've told us when
questioned about #N/A. But, ya never know!
Biff
"daddylonglegs" wrote in message
...
....or you have #NAME? errors somewhere within your data....
"T. Valko" wrote:
The only thing that will cause the #NAME? error is if your sheet name is
misspelled or does not even exsist.
Biff
"Tammy" wrote in message
...
THANKS. If I don't type CSE - then I get 0 (zero), If I type CSE using
Valko's I get #Name?
any ideas on what I"m going wrong?
"T. Valko" wrote:
There's nothing wrong with your formula. You have an extra set of
unneeded
( ) but that won't have a negative impact:
=AVERAGE(IF((ByDay!B1:B65000="LAZ")*(ByDay!HI1:HI6 50000%),ByDay!HI1:HI65000))
Biff
"Tammy" wrote in message
...
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
|