Thanks Marcol for sending reply. But issue not solved while using the formula.
=IF(ISERROR(AVERAGE(A1,B1,C1,D1,E1,F1)),0,AVERAGE(A1,B1,C1,D1,E1,F1))
It returns Average as = 0.
For more clarity,
A2 42.5
B2 #DIV/0! (Linked cell to another sheet)
C2 46.1
D2 43.7
E2 #DIV/0! ! (Linked cell to another sheet)
F2 #DIV/0! ! (Linked cell to another sheet)
I need to calculate average for A21, B2, C2, D2, E2 & F2. Keeping same values as I mentioned
When I put simple average formula =AVERAGE(A1:F1) of above range if shows #DIV/0! as resultant.
Need some logical test so that formula should get average of specified range by ignoring #DIV/0! from cells & average should be 37.5 in the case above.
Cheers.
Bookmarks