I have 3 columns of Data, Location, Date and Stock Variances. I wish to Add
up The total PLUS Stock Variances per Location in one cell and the MINUS
Stock Variances per Location in another cell.

My data is variable in length, thus I will assign Range Names to the 3
columns. I am not sure how I can add up and distinguish both Location and
whether the Stock variance is either Positive or negative.


Thanks