SUMIF for an AVERAGE
I have a rather complex (at least to me) question... My worksheet has column
D with agent initials and column AE with a score. I'm trying to figure out
the formula to calculate an average score for each agent in column D based on
amount in AE?
Column D Column AE
AMJ 5
CLY 10
KRR 2
AMJ 5
KRR 3
DZL 2
etc., etc. Sometimes I'll have 100+ rows of information.
Any help is appreciated!
Tia B
|