View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default HELP!! SUMIF QUESTION

I'm sure i've misunderstood here but anyway. Why not have the formulas

=SUMIF(A:A,"x",B:B) in C2
=SUMIF(A:A,"y",B:B) in C4

Add any new data to the bottom of cols A & B and then sort them. You formula
will remain in C2 and C4.

Mike

"kahuna" wrote:

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?