find an average from a range, utilizing all data > 0

[Chase]

I have a row of various #s and I would like to take the average of those
numbers only if they are greater than 0, if they are less than or equal to 0
I would like to omit them.

How can create a formula to reflect this?

Thanks,
CT

[Biff]

Hi!

Try one of these:

=SUMIF(A1:G1,">0",A1:G1)/COUNTIF(A1:G1,">0")

This one is an array and must be entered using the key combo of
CTRL,SHIFT,ENTER:

=AVERAGE(IF(A1:G1>0,A1:G1))

Biff

"Chase" <[email protected]> wrote in message
news:[email protected]...
>I have a row of various #s and I would like to take the average of those
> numbers only if they are greater than 0, if they are less than or equal to
> 0
> I would like to omit them.
>
> How can create a formula to reflect this?
>
> Thanks,
> CT

[Ron Coderre]

Try something like this:
=SUMIF(B1:H1,">0")/COUNTIF(B1:H1,">0")

Does that help?

--
Regards,
Ron


"Chase" wrote:

> I have a row of various #s and I would like to take the average of those
> numbers only if they are greater than 0, if they are less than or equal to 0
> I would like to omit them.
>
> How can create a formula to reflect this?
>
> Thanks,
> CT

[Biff]

Actually, the first formula can be written like:

=SUMIF(A1:G1,">0")/COUNTIF(A1:G1,">0")

Biff

"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> Try one of these:
>
> =SUMIF(A1:G1,">0",A1:G1)/COUNTIF(A1:G1,">0")
>
> This one is an array and must be entered using the key combo of
> CTRL,SHIFT,ENTER:
>
> =AVERAGE(IF(A1:G1>0,A1:G1))
>
> Biff
>
> "Chase" <[email protected]> wrote in message
> news:[email protected]...
>>I have a row of various #s and I would like to take the average of those
>> numbers only if they are greater than 0, if they are less than or equal
>> to 0
>> I would like to omit them.
>>
>> How can create a formula to reflect this?
>>
>> Thanks,
>> CT
>
>

[Ashish Mathur]

Hi,

You may try the following array formula (Ctrl+Shift+Enter)

=average(if((range>0),range))

Regards,

Ashish Mathur

"Chase" wrote:

> I have a row of various #s and I would like to take the average of those
> numbers only if they are greater than 0, if they are less than or equal to 0
> I would like to omit them.
>
> How can create a formula to reflect this?
>
> Thanks,
> CT