counting multiple cells with different items

[dja823]

I need to count how many 1st, 2nd,3rd,4th, and 5th responses were received in each area by month.

if anyone knows how to solve this i would be greatful. Thank you

[DonkeyOte]

dja823, if we assume the following:

1. solution must be compatible with XL2003 (precludes COUNTIFS)

2. you must show 0 for each point within the results matrix where no combination exists (precludes Pivot)

I would suggest for sake of performance you do the following:

Please Login or Register  to view this content.

[dja823]

Thank you this was helpful and quick