Formula to calculate revenue for certain products (averageif)

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Wrong post

Thanks, I added a file.

H3=IFERROR(AVERAGE(IF($A$2:$A$12=$G3,$B$2:$B$12*$C$2:$C$12)),"")

Control+Shift+Enter


Copy down

Another option
=AVERAGE(FILTER($B$2:$B$12,$A$2:$A$12=G3)*FILTER($C$2:$C$12,$A$2:$A$12=G3))

Thanks a lot, this is very helpful.

Glad to help & thanks for the feedback.