LinkBack URL
About LinkBacks
In D2, enter the formula
=IF(C2=0,0,SUMIFS(B:B,A:A,A2,C:C,0))
Or use this, to hide the 0 values:
=IF(C2=0,"",SUMIFS(B:B,A:A,A2,C:C,0))
Then copy down.
In D2, enter the formula
=IF(C2=0,0,SUMIFS(B:B,A:A,A2,C:C,0))
Or use this, to hide the 0 values:
=IF(C2=0,"",SUMIFS(B:B,A:A,A2,C:C,0))
Then copy down.
Last edited by Bernie Deitrick; 02-17-2016 at 11:00 AM.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks