counting adjacent cells that match a criteria

[chrisvacek]

Hey All,

Thanks in advance for your help. I have already had a great experience with this site and plan to continue visiting

My question deals with the attached excel sheet. What I would like to do here is count the total number of times each SKU in sheet (sell thru week 1) is ordered in total sales week 1 by a specific person.

Essentially the formula needs to crawl through total sales week 1 look at each row to see if the sku matches, and if the created by field is gm2011. If possible I would like to be able to copy the formula into the lower cells to get the total amount shipped by gm2011 per sku.

Thanks in advance! What takes you guys 30 seconds takes me 4 hours!