| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whats wrong with this function?
B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"")
It works fine when there is a number in B34 but if B34 is blank, even though C34 and D34 are not blank, B45 is still blank. How can I fix this so a number in any of the 3 fields will produce a number in B45? Thanks ^_^ |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Whats wrong with this function?
Give this a try...
=IF(COUNTA(B34:D34)0, AVERAGE(B34:D34),"") -- Rick (MVP - Excel) "Angelsnecropolis" wrote in message ... B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"") It works fine when there is a number in B34 but if B34 is blank, even though C34 and D34 are not blank, B45 is still blank. How can I fix this so a number in any of the 3 fields will produce a number in B45? Thanks ^_^ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Whats wrong with this function?
I think that you mean
=IF(COUNT(B34:D34)0, AVERAGE(B34:D34),"") or even =IF(COUNT(B34:D34), AVERAGE(B34:D34),"") -- __________________________________ HTH Bob "Rick Rothstein" wrote in message ... Give this a try... =IF(COUNTA(B34:D34)0, AVERAGE(B34:D34),"") -- Rick (MVP - Excel) "Angelsnecropolis" wrote in message ... B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"") It works fine when there is a number in B34 but if B34 is blank, even though C34 and D34 are not blank, B45 is still blank. How can I fix this so a number in any of the 3 fields will produce a number in B45? Thanks ^_^ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Whats wrong with this function?
Thanks for the help. That worked.
"Bob Phillips" wrote: I think that you mean =IF(COUNT(B34:D34)0, AVERAGE(B34:D34),"") or even =IF(COUNT(B34:D34), AVERAGE(B34:D34),"") -- __________________________________ HTH Bob "Rick Rothstein" wrote in message ... Give this a try... =IF(COUNTA(B34:D34)0, AVERAGE(B34:D34),"") -- Rick (MVP - Excel) "Angelsnecropolis" wrote in message ... B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"") It works fine when there is a number in B34 but if B34 is blank, even though C34 and D34 are not blank, B45 is still blank. How can I fix this so a number in any of the 3 fields will produce a number in B45? Thanks ^_^ |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Whats wrong with this function?
Thanks for the help!
"Rick Rothstein" wrote: Give this a try... =IF(COUNTA(B34:D34)0, AVERAGE(B34:D34),"") -- Rick (MVP - Excel) "Angelsnecropolis" wrote in message ... B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"") It works fine when there is a number in B34 but if B34 is blank, even though C34 and D34 are not blank, B45 is still blank. How can I fix this so a number in any of the 3 fields will produce a number in B45? Thanks ^_^ |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Whats wrong with this function?
Hi,
If you are using 2007 try this =IFERROR(AVERAGE(B34:D34),"") -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Angelsnecropolis" wrote: B45 =IF(AVERAGE(B34:D340), AVERAGE(B34:D34),"") It works fine when there is a number in B34 but if B34 is blank, even though C34 and D34 are not blank, B45 is still blank. How can I fix this so a number in any of the 3 fields will produce a number in B45? Thanks ^_^ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Whats wrong? | Excel Worksheet Functions | |||
| whats wrong with this? | Excel Discussion (Misc queries) | |||
| whats wrong with my sorting? | New Users to Excel | |||
| Whats wrong with this? | Excel Discussion (Misc queries) | |||
| Whats Wrong with this?? | Excel Worksheet Functions | |||
Hybrid Mode
