I trying to average one row if another row's value is true. I know there is a
sumif, and a countif, but couldn not find an averageif. If you could let me
know who to do this, that would be wonderful.
"eliwaite" <eliwaite@discussions.microsoft.com> wrote in message
news:8B8C3610-78A7-47E7-98E4-81055B635C41@microsoft.com...
> I trying to average one row if another row's value is true. I know there
is a
> sumif, and a countif, but couldn not find an averageif. If you could let
me
> know who to do this, that would be wonderful.
>
> Thank you,
> Eli
Yes, it's an array formula which must be entered with ctrl+shift+enter,
something like.
=average(if(a1:a21="J",b1:b21)
--
Don Guillett
SalesAid Software
donaldb@281.com
"eliwaite" <eliwaite@discussions.microsoft.com> wrote in message
news:8B8C3610-78A7-47E7-98E4-81055B635C41@microsoft.com...
> I trying to average one row if another row's value is true. I know there
is a
> sumif, and a countif, but couldn not find an averageif. If you could let
me
> know who to do this, that would be wonderful.
>
> Thank you,
> Eli
eliwaite Wrote:
> I trying to average one row if another row's value is true. I know there
> is a
> sumif, and a countif, but couldn not find an averageif. If you could
> let me
> know who to do this, that would be wonderful.
>
> Thank you,
> Eli
How about
IF(*row is true*, average(array), *row not true*)
Where *row is true* is the row being checked and *row not true* is what
is expected if false ie,. "" for a null string.
--
BradHaberman
Question
Reply
Top
Answer
Notify me of replies