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