Forum Discussion
Excel Formula Help: Running Count in a Target Cell
I have 3 columns that I am working with a Date (A:A), requested (B:B), and, shipped (C:C). The problem I am running into is the following: I'd like to add the sum of column B and subtract the sum of ...
try (assuming you have excel 365:
SUM((B:B-C:C)*(B:B>C:C))
SUM((B:B-C:C)*(B:B>C:C))
- Thanks for the reply. Unfortunately, I am on Professional Plus 2016 (work computer and account). The above formula does not seem to be working for me.
- try replacing with SUMPRODUCT:
SUMPRODUCT((B:B-C:C)*(B:B>C:C))
alternatively try using CSE (ctrl-shift-enter when you enter the formula)
