Thread: [Solved] How can I sum values using SumIfs condition like ...
View Single Post
 
Old 11-27-2016, 09:53 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If your headings start in A1 then put this formula in C2 and copy down:

=IF(COUNTIF($B$2:B2,B2)=1,SUMIF($B$2:$B$20,B2,$C$2 :$C$20),"")


(For another time please remember that the actual Excel file with data is much more helpful than a picture).
Reply With Quote