average calculation

using the formula below i've been able to get the sum of column B if the
corresponding cell in column A says "spring". my question is
how can i do the same thing but to get the AVERAGE instead of the SUM.

=SUMPRODUCT(--(A2:A14="spring"),(B2:B14))

Hi!

> =SUMPRODUCT(--(A2:A14="spring"),(B2:B14))

Better:

=SUMIF(A2:A14,"spring",B2:B14)

Best:

C1 = spring

=SUMIF(A2:A14,C1,B2:B14)

For the average:

=SUMIF(A2:A14,C1,B2:B14)/COUNTIF(A2:A14,C1)

Biff

"blackstar" <blackstar@discussions.microsoft.com> wrote in message
news:40620860-96F2-4FD6-AC19-7A6F8F815B80@microsoft.com...
> using the formula below i've been able to get the sum of column B if the
> corresponding cell in column A says "spring". my question is
> how can i do the same thing but to get the AVERAGE instead of the SUM.
>
> =SUMPRODUCT(--(A2:A14="spring"),(B2:B14))