Excell average function problem

Closed
viocat - Aug 13, 2009 at 05:02 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 13, 2009 at 07:01 AM
Hello,
i have a row with 7 cell. 4 cells contain numbers, and 3 letter x. how to calculate average for the cell that do not contain letter x.
thanks in advance for your answer.

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 13, 2009 at 07:01 AM
=AVERAGE(IF(ISNUMBER(A1:A7),A1:A7,""))

hit control+shift+enter

A1:a7 is the range where your entries are. modify if necessary
0