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
 

ExcelElliott

New Member
Joined
Mar 1, 2018
Messages
40
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)
 

Forum statistics

Threads
1,077,977
Messages
5,337,506
Members
399,153
Latest member
Tsmith25

Some videos you may like

This Week's Hot Topics

Top