software

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

=SUMPRODUCT(--(A2:A14=quot;springquot;),(B2:B14))

Hi!

gt; =SUMPRODUCT(--(A2:A14=quot;springquot;),(B2:B14))

Better:

=SUMIF(A2:A14,quot;springquot;,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

quot;blackstarquot; gt; wrote in message
...
gt; using the formula below i've been able to get the sum of column B if the
gt; corresponding cell in column A says quot;springquot;. my question is
gt; how can i do the same thing but to get the AVERAGE instead of the SUM.
gt;
gt; =SUMPRODUCT(--(A2:A14=quot;springquot;),(B2:B14))