ExcelBanter - average calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - average calculation (https://www.excelbanter.com/excel-discussion-misc-queries/69562-average-calculation.html)

blackstar

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

Biff

average calculation

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" wrote in message
...
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))

All times are GMT +1. The time now is 10:06 AM.