I have a large range of data, and I need the cells in one column to calculate the sum of several cells UNLESS another paticular cell has a value greater than 0, then the value in that the corresponding cell in that column should equal that cell.
For example:
Q2 = A2+B2+C2+D2 UNLESS E2>0 THEN Q2 = E2
Does anyone what formula I need to do this?
Thanks!
Bookmarks