Want to be able to count all value in particular range that have a
value that appear in list of multiple values

eg have spreadsheet all different types computers and what versions of
o/s and service pack they are running

eg
Sheet 1
A B

Windows XP Professional SP2 Dell Inc.
Windows XP Professional SP2 Dell Inc.
Windows 2000 Professional SP4 Compaq
Windows 2000 Professional SP4 Dell Inc.
Windows 2000 Professional SP4 Dell Inc.
Windows 98 sr2 IBM
Windows XP Professional SP2 Dell Inc.
Windows XP Professional SP2 Dell Inc.
Windows 2000 Server SP4 Dell Inc.
Windows 2003 Standard Server SP1 Dell Inc.
SCO Unix 5.0.6 Compaq


Sheet 2
Windows XP Professional SP2
Windows 2000 Server SP4
Windows 2003 Standard Server SP1
SCO Unix 5.0.6


What i need to count is how many machines are (Win XP, Win 2000 Server,
Win 2003 Server ) etc