Is there an AVERAGEIF function similar to COUNTIF - how do I do i.

I need to determine the average value from a range of values for those values
in that range that are larger than a certain value. This would act similiar
to the COUNTIF function, but it doesn't seem to exist.

=SUMIF(A1:A100,"<200")/COUNTIF(A1:A100,"<200")

--
Kind regards,

Niek Otten

"John Emhof" <John Emhof@discussions.microsoft.com> wrote in message
news:CB387BD5-6B76-46D9-85D2-BCF0BE72D570@microsoft.com...
>I need to determine the average value from a range of values for those
>values
> in that range that are larger than a certain value. This would act
> similiar
> to the COUNTIF function, but it doesn't seem to exist.

Thanks! Very helpful

"Niek Otten" wrote:

> =SUMIF(A1:A100,"<200")/COUNTIF(A1:A100,"<200")
>
> --
> Kind regards,
>
> Niek Otten
>
> "John Emhof" <John Emhof@discussions.microsoft.com> wrote in message
> news:CB387BD5-6B76-46D9-85D2-BCF0BE72D570@microsoft.com...
> >I need to determine the average value from a range of values for those
> >values
> > in that range that are larger than a certain value. This would act
> > similiar
> > to the COUNTIF function, but it doesn't seem to exist.
>
>
>

this is an array formula so must be entered with ctrl+shift+enter

=AVERAGE(IF(C3:C23>3,C3:C23))

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"John Emhof" <John Emhof@discussions.microsoft.com> wrote in message
news:CB387BD5-6B76-46D9-85D2-BCF0BE72D570@microsoft.com...
>I need to determine the average value from a range of values for those
>values
> in that range that are larger than a certain value. This would act
> similiar
> to the COUNTIF function, but it doesn't seem to exist.