Lets assume Joe has to make on average "at least" 12 phone calls a day. I need to know how much he goes over each day. I dont care if he makes 12 or under.
Row 10: I added a simple subtraction formula that subracts values in row 9 minus C6 (12 calls)
cell R10 sums entire row 10. I dont want to sum negative numbers. Just the days he goes over 12. How do I only add postive numbers in this row while ignoring negative numbers?
*spreadsheet attached.
sample.PNG
Bookmarks