When another co-worker changes the values in the control area,
nothing updates.

Maybe this person has a habit of pressing the spacebar after each word,
irregardless. TRIM will take care of that, but it's not allowed in SUMIF.
Hence the sumproduct suggestion earlier.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---