MS Excell: make a total of all cells in a row minus ones with letters

Question

I am struggling with Microsoft Excell. I am using it to keep track of averages and totals.Example: ROW 1 7,5,9,4,10,A,D,0,2 Sum:37 AVG 3.9 How can I create a sum of all numbers divided by the total numbers in one row minus the cells where I put alphabets? Is there a way to skip these cells easily? Is there a formula to add up all cells with numbers minus the ones with letters?

Answer 1

your =sum(A1:I1) in J1 works fine. After that use a =count(A1:I1) in K1 and then just use =J1/K1 in L1

the =count() function will only count numbers, not letters

edit

=avg(A1:I1) only averages numbers not letters. What's the problem?

Answer 2

If my understanding is correct

Your input is as below,

A   B   C   D   E   F   G   H   I   J
1   7   5   9   4   10  A   D   0   2

then average of above numbers will be 4.75

=AVERAGE(A1:J1)

Here it calculates only numbers.

Below are the list of formulas / scenarios, which gives same result as "4.75"

=(A1+B1+C1+D1+E1+F1+I1+J1)/COUNT(B1,A1,C1,D1,E1,F1,I1,J1)
=SUM(A1:J1)/COUNT(B1,A1,C1,D1,E1,F1,I1,J1)
=SUM(A1:J1)/COUNT(A1:J1)