•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What is this Cell Notation?
See attached image.
Why is the cell notation =SUM(D50#) and not =SUM(D50:D57)?
I thought it may be shorthand for adding all the cells in a column until the current cell, or adding all the cells in a block until a empty cell, but it is not. It is not a preset length.
___________________________________
NEVERMIND
___________________________________
The cell I am referencing is an array.
D40 = ABS(E4:E11-C4:C11)
I don't use arrays very often so i had not encountered this before.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#cell notation
#array
#SUM
#ABS
#Excel
#D50#
#D50:D57
#array formulas
#adding cells
#shorthand
#column
#cell reference
#empty cell
#preset length