General Question
How do I include empty value cells in an average function in Google Spreadsheet?
Asked by tranquilsea (17775)
May 13th, 2013
I’m in the process of preparing accounts for court and the court wants me to average all the irregular expenses monthly. When I do a simple average in Google docs it only takes the month that has a value in it and ignores all the empty cells in the average solution which skews the results. I don’t want to add zeros to all the empty cells. I want each calculation to be averaged over 12.
Anyone know how I can achieve this?
Observing members:
0
Composing members:
0
2 Answers
Answer this question
This question is in the General Section. Responses must be helpful and on-topic.
Have a question?
Ask Fluther!