calculate average in percentage coloumn with #DIV/! (ignore error
calculate average in percentage coloumn with #DIV/!. When the formula has to
calculate the average of a few figures it must ignore all error if present in the some cells |
Another way (less pedagogic, though):
=AVERAGE(IF(ISNUMBER(A1:A99),A1:A99)) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) neelsels SA wrote: calculate average in percentage coloumn with #DIV/!. When the formula has to calculate the average of a few figures it must ignore all error if present in the some cells -- Dave Peterson |
All times are GMT +1. The time now is 09:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com