Thanks for the quick responses everyone. I ended up using =IF(COUNTIF($A$1:$A2,$A2)=1,SUMIF($A:$A,$A2,$B:$B),"") and it works great on the template i created. When I try to change the letters to X and Y (This is where the data is on my actual business spreadsheet) and the numbers to 6 and 7 It puts the final number one cell too high. For instance if cells x10,x11,x12 all match the formula spits out the sum on cell x9. Obviously I made a mistake in transferring the formula should I change the formula to? It is currently at =(COUNTIF($Y$6:$Y7,$Y7)=1,SUMIF($Y:$Y,$Y7,$X:$X),"")