| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I ignore cells in Excel?
I have a formula written in a column ten rows deep. Sometimes I use less
than 10 inputs. I'm trying to formulate an average of this column, but if I don't input all 10 inputs, my average comes back with #DIV/0! How can I get this column to average when some of the rows aren't being used? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
| Excel cannot shift nonblank cells | Excel Discussion (Misc queries) | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
Threaded Mode
