Support Board

Date/Time: Sun, 05 May 2024 17:53:46 +0000

Post From: How to SUM spreadsheet column consisting of +Num's,-Num's, and 0's while...

[2018-09-13 01:45:19] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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