Dear All,
I have 3 cols in sht 1
Col1 Col2 Col3
XXX date1 5.00
XXX date1 (1.00)
XXX date2 3.00
YYY date1 2.00
YYY date1 6.00
YYY date2 (9.00)
In sheet 2 A1, I would like to sum the absolute net on each date of XXX,
i.e. abs(5-1)+abs(3),expected result 7.
A2 doing the same with YYY, i.e. abs(2+6)+abs(-9),expected result 17.
I think of sumproduct() on single date but dont know how to pull different
date together (dates are non-fixed and non-sequential, no of rows could be
changed).
Any suggestion please?
Regards