Hi all.. this is my first time here so apologies for any formatting issues.. i have attached the relevant file with my data..i have input all the purchases as positive numbers and the sales that i make as negative numbers..

I am trying to create dynamic charts for the different products that i sell..also i would need dynamic charts for the products sold by a specific DSR..i know i would have to use OFFSET with COUNTIF but i am unable to get around the correct formula..also i am not sure how to convert the negative sales numbers to positive for charting purposes..



Can someone please help me..i have spend numerous hours trying to work it around but i am unable to find a solution

Attached Files

Stock Sheet.xlsx (10.0 KB, 8 views)