Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to exclude certain cells in a range
This should be a simple fix, but I'm not having any luck right now figuring
it out. Need some help to exclude cells within a range of cells. Am doing an average of 50 cells, =AVERAGE(A4:A53). Some of these cells include an asterisk and should not be included in the final average. TIA, Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to exclude certain cells in a range
=AVERAGE(IF(ISNUMBER(A4:A53),A4:A53))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Bob Smith" wrote in message ink.net... This should be a simple fix, but I'm not having any luck right now figuring it out. Need some help to exclude cells within a range of cells. Am doing an average of 50 cells, =AVERAGE(A4:A53). Some of these cells include an asterisk and should not be included in the final average. TIA, Bob |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to exclude certain cells in a range
Have you tried it?
-- Don Guillett SalesAid Software "Bob Smith" wrote in message ink.net... This should be a simple fix, but I'm not having any luck right now figuring it out. Need some help to exclude cells within a range of cells. Am doing an average of 50 cells, =AVERAGE(A4:A53). Some of these cells include an asterisk and should not be included in the final average. TIA, Bob |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to exclude certain cells in a range
Thanks for the reply Bob. Unfortunately, that formula did not work. I hope
you don't mind, but I sent you a 17K worksheet to see what I'm trying to do. Regards, Bob "Bob Phillips" wrote in message ... =AVERAGE(IF(ISNUMBER(A4:A53),A4:A53)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Bob Smith" wrote in message ink.net... This should be a simple fix, but I'm not having any luck right now figuring it out. Need some help to exclude cells within a range of cells. Am doing an average of 50 cells, =AVERAGE(A4:A53). Some of these cells include an asterisk and should not be included in the final average. TIA, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel |