Try
D2Formula:
=IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)=1,SUMIFS($C$2:$C$24,$A$2:$A$24,A2,$B$2:$B$24,B2),"")
Drag down
Try
D2Formula:
=IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)=1,SUMIFS($C$2:$C$24,$A$2:$A$24,A2,$B$2:$B$24,B2),"")
Drag down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks