Home / Mac / How do you calculate only positive values ​​in a row with rare cells in a row?

How do you calculate only positive values ​​in a row with rare cells in a row?



Hi, I just want to add positive values ​​to a cell and not a negative value in a row. But the cells I want in total in a row are every 5. Is there a formula that can do this? Thank you very much

I want to find the amount of overtime hours we pay each week to employees, and I want a monthly sum at the end of the line for each employee. How I have set up the spreadsheet to get the O / T value is:
F4 (Actual hours) – B4 (contracted hours) = E4 (O / T hours) This formula is for an employee in one week, so there are another 3 or 4 formulas that go over the rows for the month for the employee. The problem is when I get the final formula for the end of the month, I calculate the negative values, ie if the employee has not reached their agreed hours, as well as the positive values, ie if they have exceeded their agreed hours (as I want to know) Whatever formula I enter in the end, it never takes only the positive values, e.g. e4 + k4 + q4 + w4 + ac4 + ai4, ”> 0 ″ e4 + k4 + q4 + w4 + ac4 + ai4
—–
Chris


Source link