Subtotaling group with formula

[pattersong]

Hi all,
I've been struggling with this excel problem for most of the day and I'm hope someone on this forum will quickly resolve the issue. My OS is Windows 7 and I am using MS Office 2007. I tried to upload the worksheet, but I can't download the add-in due to my office security.
I have 3 columns (no headings at the moment, just working with the data). Column A consist of a,a,a,b,b,d,c,c,c. Column B consists of 5,5,5,2,1,5,2,2,1,2. Column D has the formula =IF(A2=A1,SUMIF(A:A,A2,B:B),"?"). It work pretty well, but the second row has a value of 15 (which is correct using the formula), but I want it to be blank until the next change in column A.
Thanks, in advance, for your helpful consideration. -- pattersong.

 

[bbott]

Try:

=IF(A1=A2,"",SUMIF($A$1:$A$10,A1,$B$1:$B$10))

 

[pattersong]

This is fantastic. Thank you so much for your quick response.

 

[bbott]

This is fantastic. Thank you so much for your quick response.

You're welcome.