Support Board
Date/Time: Wed, 22 Jan 2025 09:50:02 +0000
Post From: How to SUM spreadsheet column consisting of +Num's,-Num's, and 0's while...
| [2018-09-12 21:21:14] |
| User68474 - Posts: 201 |
|
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. |