CODEWITHSUNDEEP
excelvba
Frnht451
Frnht451

Reputation: 13

Calculating Multiple Averages

It's my first time posting a question to this forum. Though I have found answers here many times before, I have been unable to find a solution to my current predicament.

I work in a call center and each week I need to analyze data from the thousands of call that took place over the week. I'm new to programming in Excel-VBA but I've been able to get pretty far.

The data is produced by a third party program and the format is nigh unreadable. Much of the programming I've done so far has been geared towards making the data more organized. Now, I'd like to get into more analysis.

The data is arranged by employee number (NOT in order, though). Each employee takes several calls over the course of the week, some for which the customer takes a survey. It's the survey scores I want. I want to take the average of all the surveys for each employee and then display that average in the same row as each of the entries.

Example enter image description here

The yellow highlighted area is what I want to add. Any ideas? Thanks for any help in advance!

Upvotes: 0

Views: 64

Answers (1)

Scott Holtzman
Scott Holtzman

Reputation: 27249

No need for VBA. If you have the supported version of Excel you can use AVERAGEIF. If not you can use below formula.

Enter as an array formula by pressing Ctrl+Shift+Enter when exiting cell edit mode (instead of just enter).

=AVERAGE(IF($A$2:$A$13=A2,$B$2:$B$13))

Then copy down for all rows.

Upvotes: 1

Related Questions