I would like excel to search for all references to ex. "TV/VCR" that is being
used in a particular room ex. "PA" and keep a running total that is linked to
a cell on another worksheet labeled 'PA'. Does anyone have any ideas how
this can be done?