| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I ignore cells with errors when calculating an average?
I need to average a bunch of non-adjacent cells as follows:
=AVERAGE(B2,D2,F2,H2,J2,L2,N2,P2,R2,T2,V2,X2,Z2,AB 2,AD2,AF2,AH2,AJ2,AL2,AN2,AP2) My problem is that a couple of the cells display #DIV/0! As such, my average calcuation also compes up with #DIV/0! I would like to calculate the average but ignore any cells with the error. Suggestions? thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Non-Continuous Cells Without Zero's | Excel Worksheet Functions | |||
| Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
| How do I use an average function, not counting cells containing a | Excel Worksheet Functions | |||
| average cells omitting nulls | Excel Worksheet Functions | |||
| how do you ignore blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
