View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TiaB TiaB is offline
external usenet poster
 
Posts: 2
Default 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