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


--
silencebreaking
------------------------------------------------------------------------
silencebreaking's Profile: http://www.excelforum.com/member.php...o&userid=35328
View this thread: http://www.excelforum.com/showthread...hreadid=550998