Support Board
Date/Time: Tue, 04 Nov 2025 07:35:50 +0000
Post From: How to SUM spreadsheet column consisting of +Num's,-Num's, and 0's while...
| [2018-09-13 01:45:19] |
| Sawtooth - Posts: 4285 |
|
A SUMIF example, where P3 is the column with -, +, and zeros: Q3: =IF(P3>0,P3,0) R3: =SUM(Q3:Q1002) this will sum positive numbers S3: =IF(P3<0,P3,0) T3: =SUM(S3:S1002) this will sum negative numbers |