x 10
x 11 21
y 12
y 10 22

I`m using SUMIF to return the sub total values for x and y in column C
above, however I want only to show the values 21 and 22 above in C2 and C4
only and not anything in C1 and C3...basically so I can copy the formulas
down and not have to manually amend....

One solution is to include =IF(A1=A2,0,SUMIF( etc, which is great, but when
I insert a new row with another value for x, then row, the A1=A2 bit becomes
A1=A3, which is no good...B
The idea is that I want to maintain a table with subtotals for x and y and
have the ability to add in further rows....anybody have any ideas?