SignalServ
New Member
- Joined
- Sep 21, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a sheet which calculates totals in column H. I need to be able to total only the positive numbers. The column looks like this:
5
4
3
2
1
0
-2
-5
-23-6
The location of the Zero changes depending on the data is entered, but it is always there somewhere. Would someone be able to help me with a formula that
I can use to total only thise numbers that are greater than zero (not zero or anything less than zero).
Thanks!
5
4
3
2
1
0
-2
-5
-23-6
The location of the Zero changes depending on the data is entered, but it is always there somewhere. Would someone be able to help me with a formula that
I can use to total only thise numbers that are greater than zero (not zero or anything less than zero).
Thanks!