SOLVED

Average

Copper Contributor

AlexEanbu_0-1695044363516.png

 

fx= Average of Product from jan to apr?

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

10 Replies
Did you try to use AVERAGEIFS() function?

@AlexEanbu 

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.

CAN U PLS ELOBRATE

@AlexEanbu 

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

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

@AlexEanbu 

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?

@Hans Vogelaar here I have attached , workbook .

best response confirmed by AlexEanbu (Copper Contributor)
Solution

@AlexEanbu 

You could use

 

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

thank you so much, it works :)
1 best response

Accepted Solutions
best response confirmed by AlexEanbu (Copper Contributor)
Solution

@AlexEanbu 

You could use

 

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

View solution in original post