General Question

tranquilsea's avatar

How do I include empty value cells in an average function in Google Spreadsheet?

Asked by tranquilsea (17238 points ) 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

tranquilsea's avatar

I think I figured it out. I’m glad Google spreadsheets obey the laws of math lol.

jaytkay's avatar

How did you do it?

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther