Support Board
Date/Time: Wed, 22 Jan 2025 09:48:29 +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: 4158 |
|
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 |