•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