hello daddylonglegs,

your formula works beautifully, thx you.

quick question regarding capturing additional fields.

i need to capture additional metrics for the sales ppl (i.e. the range in E6:Y6)...things such as, # of calls they made etc etc, with respective to the city they work for.

so, ie. in washington, what the total days worked was for i.e. P1W1?

i thought it was the same formula as above and changing the beginning portion to (E$7):
=COUNTIF(OFFSET(Sheet2!E$7....

but that is not getting me the right answer. any suggestions, pls and thx you