Support Board

Date/Time: Sun, 05 May 2024 19:18:38 +0000

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

[2018-09-12 21:21:14] Link To Thread - Link To Post [Go To First Post]
User68474 - Posts: 195
How can I SUM a spreadsheet column consisting of +Num's,-Num's, and 0's, trying to SUM three different ways: 1.) Get a total by disregarding the negative signs; 2.)Total of positive only; 3.) Total of negative only. ALSO, I'd like to know how to get the total number of entries in any given column(i.e. "rows",I guess) after eliminating all the "0"s. From previous help on this Forum, I learned how to create the "IGNOREZEROS" formula. I realize I can probably "extrapolate" this by summing and then averaging and then dividing the sum by the average. But I figure there must be a more "sophisticated" way via a formula of some sort which will be helpful for creating other more complex formulae if desired. You out there, "tomglib"? Hope so.