I'm trying to setup a formula that calculates the sum of a range if either of 2 cells are greater than zero but all it returns is a #VALUE! error. For example B4 has a value of 160, C4 is 0, D4 is 401000, E4 & F4 are both zero should return 401000 in G4. Whereas, B5 being 22032, C5 is 74000, D5 at 64000, E5 is 600 and F5 is 1110 should return 160,032. I have included what I've done so far as the formula with the error, but I'm stuck atm.
Please Login or Register to view this content.
Bookmarks