John,

You can try this:

=SUMPRODUCT(--(varianceRange<0)*(locationRange=LocationCodeOrNam e),varianceRange)

Will add all variance smaller than zero for a given location.

Regards,
Robert