Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 145
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 347
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 145
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 145
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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






  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 287
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 10:40 PM
Formula Recalculation Error uknow message board Excel Worksheet Functions 2 September 21st 06 05:33 PM
Let me save/close EXCEL if a formula I put in has an error in it Tony Borg Setting up and Configuration of Excel 1 September 2nd 06 04:13 AM
remove error value when formula exists for empty cells Cyrus Excel Worksheet Functions 2 February 17th 06 05:19 PM
I get error with "ROWS" in the formula - nested formula question Marie J-son Excel Worksheet Functions 0 January 4th 06 02:55 PM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"