Hello All, i have a .xls file with Sheet 1 as
Date Name qty
1 x 10
1 x 50
1 x 30
1 y 40
1 y 60
1 z 80
2 x 25
2 x 25
2 y 30
2 y 45
2 y 50
3 z 60
4 x 52
4 y 6
4 y 80

In Sheet 2 I have formatting like this
Date 1 2
3 4 (so on)
x <total of x for date 1 <total of x for date 1
y
z

Is there any formula or way to get subtotals for x,yand z for each
date.
example
Date 1 2
3 4 (so on)
x 90
y 100
z 80

Please help