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?
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.



your the edit



If my understanding is correct Your input is as below,
then average of above numbers will be 4.75
Here it calculates only numbers. Below are the list of formulas / scenarios, which gives same result as "4.75"


