SOLVED

# Average

Copper Contributor

# Average fx= Average of Product from jan to apr?

Which Means sum of each month of DVD and their Average?

10 Replies

# Re: Average

Did you try to use AVERAGEIFS() function?

# Re: Average

Assuming that "product/month" is in A1, enter the following formula in a cell in row 2:

=AVERAGE(\$B2:\$E2)

Fill down.

Or should the rows containing "product 2" be combined? If so, enter the formula

=UNIQUE(\$A2:\$A5) in a cell, for example in P2.

In the cell next to it, enter the formula

=AVERAGE(IF(\$A\$2:\$A\$5=P2#, \$B\$2:\$E\$5))

Adjust the ranges if you have more data rows.

# Re: Average

CAN U PLS ELOBRATE

# Re: Average

You changed the screenshot since I composed my reply. My reply was based on the original screenshot.

In H2:

=AVERAGE(IF(\$A\$2:\$A\$18=G2, \$B\$2:\$E\$18))

# Re: Average

I Dont know , how could it work?
not working bro

can you sort it

# Re: Average

If you do not have Excel 2021 or Excel in Micorosft365, confirm the formula by pressing Ctrl+Shift+Enter.

If that doesn't work: Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

# Re: Average

@Hans Vogelaar here I have attached , workbook .

best response confirmed by AlexEanbu (Copper Contributor)
Solution

# Re: Average

You could use

=SUMPRODUCT(\$C\$2:\$F\$19*(\$B\$2:\$B\$19=H2))/COUNTA(\$C\$1:\$F\$1)

# Re: Average

thank you so much, it works :)