| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average/Sumif based on several columns | Excel Worksheet Functions | |||
| Average/Sumif based on several columns | Excel Worksheet Functions | |||
| Weighted average using SUMIF and/or SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Excluding Zero's from Average (SumIF / CountIF) | Excel Worksheet Functions | |||
| Using VLookup, Displacement, SumIF to total and average | Excel Discussion (Misc queries) | |||
Threaded Mode
