Re: excel questions
toggle quoted messageShow quoted text
For your situation, you could try using the sum function combined with the count function.
Another words, you could get the sum of numbers in the range of cells, then use the count function to divide by the number of numbers you have. This would hopefully get rid of your error.
In your example, try this formula:
I noticed that you did not include c102 in your formula, so I left it out.
=sum(b102, d102:m102)/counta(b102, d102:m102)
Let me know if you have any questions.
On Nov 18, 2016, at 3:40 PM, stintonjoe@... wrote: