I have a formula that gives me an answer of the number of days a case was
worked on. This column has 1500 rows, I want to take the 1500 rows of
numbers and generate an average in a cell at the top of the page.
Question, some of the rows contain a negative number and I do not want any
negative numbers to be reflected in the average formula. How can I create a
formula to average Column x3:x1500 and leave out the cells with the negative
numbers?

Thanks,

=sumif(x3:x1500,">=0") / countif(x3:x1500,">=0")

or maybe:

=if(countif(x3:x1500,">0")=0,"No data!",
sumif(x3:x1500,">=0") / countif(x3:x1500,">=0"))




Pammy wrote:
>
> I have a formula that gives me an answer of the number of days a case was
> worked on. This column has 1500 rows, I want to take the 1500 rows of
> numbers and generate an average in a cell at the top of the page.
> Question, some of the rows contain a negative number and I do not want any
> negative numbers to be reflected in the average formula. How can I create a
> formula to average Column x3:x1500 and leave out the cells with the negative
> numbers?
>
> Thanks,

--

Dave Peterson