Mean Paid Per ID

Page0727

New Member
Joined
Nov 2, 2018
Messages
20
I am using the following to calculate the mean per row where the ID's are the same.

=IF(A4=A3,"",SUMIF(A:A, A4,E:E )/COUNTIF(A:A, A4))

Column A contains my ID's, Column E contains the paid amounts. This works except for the fact that if there are 2, 3, 4 matching ID's it will not populate the 2nd, 3rd, or 4th where the ID matches. Is there a way around this?

Thank you
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

ExcelElliott

New Member
Joined
Mar 1, 2018
Messages
41
So are you trying to do a running average? Because if not, you should just be able to use AVERAGEIF(A:A,A4,E:E)
 

Watch MrExcel Video

Forum statistics

Threads
1,090,443
Messages
5,414,523
Members
403,532
Latest member
mikexcel12

This Week's Hot Topics

Top