Formula_Newbie
New Member
- Joined
- Mar 16, 2022
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
I need help with a formula that says if a single cell within these ranges contain a negative number return 0 or don't add, and if all the cells are positive numbers, then sum. For example, A6:A8 has a negative number in one of the cells, therefore I just want the result to be zero, instead of 14.65. Your help will be much appreciated!!