Help

[Shani]

Here is my issue, I am going to try and explain this clear as possible, so
please bare with me.

How do I do a sumproduct for this?? This is all set up by team on the sheet
I am working off of. Here is the example by column

team name:employee name:total number of forms;average score

I have a cover sheet that has each team listed and I need to have an overall
average score for that team. The average needs to be weighted against the
total number of forms. How can I return the overall avg score for that team
on my cover sheet?? I hope this make sense??

Thanks

[MWE]

Hi Shani:

there are many ways to do this; most require some additional fields. The most general and flexible is to use VBA (macro). Attached is a zipped sample spreadsheet that uses a VBA macro to do what I think you want.

It has two worksheets, one called Teams and another called IndivScores. The team names and other data is just stuff I made up. On the Teams tab is a yellow command button that executes the actual macro. The macro is written so that it figures out how many team there are, how many individuals, etc. It does not check for duplicate team names, individual names, wrong # of forms (whatever that might be), bad scores (whatever that might be), etc., but that could be easily added.

Let me know if this does what you want.