I have a workbook that has 9 worksheets in it. The first 8 sheets are named May 2006, June 2006, etc etc etc. The 9th sheet is named Monthly Totals.
I'm tracking commission bonus points with this workbook. I know that I've seen a formula for doing this, but the reference site I saw it on has been blocked and the boss won't be in until later today and I want to get this done before then (if possible).
On the Monthly Totals sheet, I have the listing of all the sales guys in column A, and each month is listed in columns B - H. I would like to have the Monthly Totals sheet pull all the commission totals for George Smith in May, and enter that total amount on his corresponding cell, and then do the same thing for all the other sales guys, in all the other months.
Thank you so much for any help you may be able to give me! I appreciate it!
Samantha
Bookmarks