Excell average function problem [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
792
=AVERAGE(IF(ISNUMBER(A1:A7),A1:A7,""))

hit control+shift+enter

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!