How do I Link two worksheets?

[Guest]

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?

 

[JulieD]

Hi

not sure exactly what you're after but check out COUNTIF in help and see if
that is useful - or the
SUMPRODUCT function at

http://www.xldynamic.com/source/xld.SUMPRODUCT.html