Counting Distinct values, number and text

GWHotmail 

It's been seven hours, over 35 views.... your short fuse might just burn down to the nub.

The spreadsheet you have posted is perhaps clear to you in terms of how to navigate its various sections, but isn't all that clear to somebody seeing it for the first time.

I am going to guess that everybody else who has looked at it and not responded has had the same reaction; I'm just doing the courtesy of letting you know....if you want help, you're going to need to make the organization of your sheet a LOT clearer.

It might benefit from having the extensive database on one sheet by itself, anchored in the upper left hand corner. Then take the various areas meant to extract and analyze the database, to produce those desired results, and place them on their own sheet, and there too not separated by all kinds of white space.

You might even benefit from being able to see things more clearly. You certainly would improve your chances of getting a more substantive reply.