Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add up Plus & Minus Figures separately by Location
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Excellent Robert, exactly what I needed
Thanks "cmart02" wrote in message ... John, You can try this: =SUMPRODUCT(--(varianceRange<0)*(locationRange=LocationCodeOrNam e),varianceR ange) Will add all variance smaller than zero for a given location. Regards, Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change location of figures within a column | Excel Worksheet Functions | |||
Add a default location for print to file in Excel. | Excel Discussion (Misc queries) | |||
minus formel/fortegn | Excel Discussion (Misc queries) |