monthly total

[EricaTippin]

Need to pull out each employee and add each pay date to find their total pay for each month

Employee Number

average pay jan

average pay feb

average pay march

[nagakavyasri · Accepted solution]

@EricaTippin 

Try this

[EricaTippin]

Perfect

What if I need to Join the Employee number with their Name from the second sheet of the Excel file

Employee No

Employee name

Total for Month

[nagakavyasri]

@EricaTippin   Join by Emp no