I've searched for the answer to this, but I may not have the terminology right to get the answer.
In Cell A1 I have a simple addition formula such as =8+3+5+2 which gives me the result of 18.
What I want (say in Cell B1) now is to find the average of those numbers based on the number of arguments or inputs. In this case it would be four. I know the fourmula =A1/4 would give me the answer but,
I want excel to recognize the number of inputs to perform the average, I do not want to have to specifically change the formula in cell B1 every time based on the number of inputs.
Thanks
In Cell A1 I have a simple addition formula such as =8+3+5+2 which gives me the result of 18.
What I want (say in Cell B1) now is to find the average of those numbers based on the number of arguments or inputs. In this case it would be four. I know the fourmula =A1/4 would give me the answer but,
I want excel to recognize the number of inputs to perform the average, I do not want to have to specifically change the formula in cell B1 every time based on the number of inputs.
Thanks