Averaging formula error

[Guest]

Please tell me what's wrong with my formula.

=AVERAGE(IF(((ByDay!B1:B65000="LAZ")*(ByDay!HI1:HI65000>0%)),ByDay!HI1:HI65000))

then I'm doing CSE

 

[Don Guillett]

Looks OK except for too many (), but OK anyway

 

[T. Valko]

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:HI65000>0%),ByDay!HI1:HI65000))

Biff

 

[Guest]

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

 

[Guest]

Hi - I don't have any #N/A in HI

=AVERAGE(IF(((ByDay!B1:B65000="LAZ")*(ByDay!AI1:AI65000>0%)),ByDay!AI1:AI65000))

changed the column to AI anyway - I'm getting a #NAME? error

 

[Guest]

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]

The only thing that will cause the #NAME? error is if your sheet name is
misspelled or does not even exsist.

Biff

 

[Don Guillett]

Is it ByDay or By Day with a space?

 

[Guest]

.....or you have #NAME? errors somewhere within your data....

 

[T. Valko]

....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