Hi Excel Guru,
I need the below condition for attached screen short.
If sales < 0 then count (# Transactions),sum(Sales) and sum(QTY)
If sales >0 then count (# Transactions),sum(Sales) and sum(QTY)
Country ID # Transactions Sales QTY
14 2,685,075,440 -802.9 -10
14 2,685,075,441 -665 -9
15 2,685,075,442 -640 -3
15 2,685,075,443 -636 -7
15 2,685,075,444 620 10
15 2,685,075,445 576 5
30 2,685,075,446 528.8 6
30 2,685,075,447 -519.18 -5
30 2,685,075,448 -504 -7
30 2,685,075,449 386.25 5
30 2,685,075,450 -360 -6
30 2,685,075,451 342.88 3
44 2,685,075,452 -323.19 -6
44 2,685,075,453 303.98 6
44 2,685,075,454 -294.4 -3
44 2,685,075,455 -293.1 -4
44 2,685,075,456 290.4 4
44 2,685,075,457 288.75 5
44 2,685,075,458 287.3 3
Please help me and thanks for you help.
Bookmarks