|
Averaging formula error
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 |
Averaging formula error
Looks OK except for too many (), but OK anyway
-- Don Guillett SalesAid Software "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 |
Averaging formula error
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 |
Averaging formula error
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 |
Averaging formula error
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 |
Averaging formula error
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 |
Averaging formula error
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 |
Averaging formula error
.....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 |
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 |
| All times are GMT +1. The time now is 01:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com