Login Page - Create Account

Support Board


Date/Time: Mon, 13 May 2024 21:12:06 +0000



Spreadsheet Study: Get all the data in the row of one column.

View Count: 674

[2019-03-16 03:03:43]
||||||||||||||||||||| - Posts: 18
What is the function code to call in every available data in a specific column? I want to use it on a SUM function, I want to sum all the data in one column/cell, I can't just type SUM(A), SUM(B), SUM(C).
[2019-03-16 17:19:40]
bradh - Posts: 857
What is the function code to call in every available data in a specific column? I want to use it on a SUM function, I want to sum all the data in one column/cell, I can't just type SUM(A), SUM(B), SUM(C).

If you have 1000 rows, then the sum of all entries in column x is:

=sum(X3:X1002)

[2019-03-17 00:10:43]
||||||||||||||||||||| - Posts: 18
Thank you.
This is exactly my current solution.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account