Hi Gary,
Sorry reply to you one day late, I tried to reply to you twice on yesterday
but both were rejected saying service temporary out.
Thanks for your suggestion. However, as I am not familiar with pivot table,
I know that it has sum on grouping function but I dont know how to arrange
that. Besides, does it also able to make the sum result of each group as
absolute value (making the negative result as positive value) then total of
all groups?
Regards


"Gary''s Student" wrote:

Consider using a pivot table. The advantage is that you don't need to
pre-define a list of possible XXX's or dates.
--
Gary''s Student - gsnu200909


"Seeker" wrote:

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