average calculation

[Guest]

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))

 

[Biff]

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