Forum Discussion
Average
I am trying to establish the average value of a series of numbers in a string of individual cells in Excel. So, for example I have spreadsheet with whole number values in numerous separate cells that...
With COUNT(+J6+N6+R6+...) your adding up the values - becoming one value. And the count of one value is 1.
More appropriate would be COUNT(J6,N6,R6,...).
And you should change your model. It should be a data list. Calculating will be much more simple and efficient.
Thank you Detlef_Lewin !! Will definitely go with your suggestion!
I don't understand when you say to change my model to a data list. Could you please clarify on that?
This is an example of a record list:
Unique column names. Each column has the same data type (text, number, date, ...) in every row.
Thank you, Detlef_Lewin, got it!
I am a 74 year-old "learner", as you might have already worked out!!