Excell average function problem

Question

Excell average function problem

Closed

Report

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.

Excell average function problem
Excel if function with date range - How-To - Excel
Excel if function if cell contains specific text ✓ - Forum - Excel
Excel multiple functions in one cell - Forum - 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: 1864
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: August 7, 2021

804
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

1 reply

Your reply

Subscribe To Our Newsletter!