problem:
Column A has specific names
Column B has specific times in mins
Column C has the number of task completed in said time
I wanted to have a overall average per person of how many task were completed in a hour
The fourmula that solved my issue, as simplified as I could get it with the help of others
=SUMIF(A:A,"*Dave*",C:C)/SUMIF(A:A,"*Dave*",B:B)*60
Bookmarks