I got a nice head scratcher for you guys! I'm still on basic formulas so I could use a little help
1. They want to have the total $ amount from the 'MTD Funded' from each monthly tab for each individual. (Highlighted In Yellow)
Example: On Combined Data page, I need the total from MTD funding for Robert Fishman from the Jan (Jan - E4) tab to show under the January (Combined data - C3) column.
2. They want to have the total unit count from the 'MTD Funded' from each monthly tab for each individual. (Highlighted In Green)
Example: On Combined Data page, I need the total from MTD funding for Robert Fishman from the Jan (Jan - E4) tab to show under the January (Combined data - C27) column.
The (#) are the Unit counts, can the formula search just for the $ or should I separate the Unit count?
3. They then want to know what % for each team for the total unit count. (Highlighted In Blue)
Example: (C44+C45+C46) divided by the total unit count (C47) = contribution % (C51)
I hope you guys can help
BSR Teams - 2013.xlsx
Bookmarks