Excell average function problem [Closed]

Question

Excell average function problem [Closed]

Report

viocat - Aug 13, 2009 at 05:02 AM
venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

- 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.

Excell average function problem
Excel if function with date range - How-To - Excel
Excel show function bar - How-To - Excel
Vba excel search function - How-To - Excel
Excel print function ✓ - Forum - Excel
Excel If Function over a range of dates - How-To - Excel

1 reply

Ask a question

venkat1926 · Answer 1 · 2009-08-13T07:01:47-0400

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

796
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

Excell average function problem [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!