| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average range including blank cells: #DIV/0!
I am trying to average a range of cells which sometimes includes blank cells, which returns: #DIV/0! This happens when the entire range is blank, but works fine when data is present. I would also like for it to display "NO" instead of #DIV/0! The formula I used was: =AVERAGE(B4:M4) Any help is much appreciated! -- Areaka ------------------------------------------------------------------------ Areaka's Profile: http://www.excelforum.com/member.php...o&userid=33426 View this thread: http://www.excelforum.com/showthread...hreadid=532426 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average range including blank cells: #DIV/0!
Areaka, =IF(ISERROR(AVERAGE(B4:M4)),"NO",AVERAGE(B4:M4)) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=532426 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average range including blank cells: #DIV/0!
one mo
=if(count(b4:m4)=0,"NO",average(b4:m4)) Areaka wrote: I am trying to average a range of cells which sometimes includes blank cells, which returns: #DIV/0! This happens when the entire range is blank, but works fine when data is present. I would also like for it to display "NO" instead of #DIV/0! The formula I used was: =AVERAGE(B4:M4) Any help is much appreciated! -- Areaka ------------------------------------------------------------------------ Areaka's Profile: http://www.excelforum.com/member.php...o&userid=33426 View this thread: http://www.excelforum.com/showthread...hreadid=532426 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average range including blank cells: #DIV/0!
Oh, thank you so much, I was working it and reworking it with IF functions and not getting anywhere. I plugged yours in and instantaneous!!! Thank you so much!!!! -- Areaka ------------------------------------------------------------------------ Areaka's Profile: http://www.excelforum.com/member.php...o&userid=33426 View this thread: http://www.excelforum.com/showthread...hreadid=532426 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to combine including blank cells | New Users to Excel | |||
| Counting blank cells until value is reached | Excel Worksheet Functions | |||
| How do I average a range of cells when one cell contains #N/A | Excel Discussion (Misc queries) | |||
| How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
Linear Mode
