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