Associate
- Joined
- 25 Jul 2005
- Posts
- 892
im pretty sure i have done this at some point in the past, but cannot remember how!
what i want is simple and straight forward.
i have a column of data, but there are spaces in it. i am wanting to caltulate the average of all the cells containing data, and for this to not include the empty cells then the total is divided.
eg
a1:a6 would divide by 6, but if one if them is empty i wont get the true average.
hopefully this makes sense, and someone can help.
thanks
DM
what i want is simple and straight forward.
i have a column of data, but there are spaces in it. i am wanting to caltulate the average of all the cells containing data, and for this to not include the empty cells then the total is divided.
eg
a1:a6 would divide by 6, but if one if them is empty i wont get the true average.
hopefully this makes sense, and someone can help.
thanks
DM