Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Formula Recalculation Error | Excel Worksheet Functions | |||
Let me save/close EXCEL if a formula I put in has an error in it | Setting up and Configuration of Excel | |||
remove error value when formula exists for empty cells | Excel Worksheet Functions | |||
I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions |