Try
=IF(SUM(J4:J12),0,SUM(K4:K12))
However, as pointed out by Ford in post #3, this remain zero as long as there is a "1" in column J
Try
=IF(SUM(J4:J12),0,SUM(K4:K12))
However, as pointed out by Ford in post #3, this remain zero as long as there is a "1" in column J
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks