Hello -
I'm trying to do a weighted average based on 2 columns; numbers and percentages from 2 tables. (see attached for basic example)
General Concept (2 tables)
Table 1
- I have 4 Queues for a call center
- Column A = Queue Name
- Column B = Number of Calls
- Column C = Percentage of calls in the queue vs all queues
Table 2 Scores for each queue
- Column A = Queue Name
- Column B = Score for the queue
What I want
- I need to do a weighted average of the scores based on the percentage of calls in the queue but omit zero's from the Score table. I've tried sumproduct but can't figure out how to omit the zero's and still do the weighted average. Since in this example the last queue in the score table is zero I'd want a sumproduct of the first 3 queues (Score*% of total)
any thoughts are appreciated.
thanks.
Bookmarks