How to make a formula calculate entire collumn A, instead of a normal range such as A4:A30, i want A:A or all A collumn?
In this formula =SUM(A4:A30) would calculate entire Collumn A:A
How to make a formula calculate entire collumn A, instead of a normal range such as A4:A30, i want A:A or all A collumn?
In this formula =SUM(A4:A30) would calculate entire Collumn A:A
Try
= SUM(A:A)
Martin
=SUM(A:A)
But do be careful when you use entire column as range arguments in formula. Majority of formula will not shrink down to used range, and will iterate over entire column. Slowing down workbook performance.
I'd recommend use of dynamic named range, or structured table reference rather than using entire column.
Edit: See links for how to use dynamic named range/structured table reference.
https://www.excel-easy.com/examples/...med-range.html
https://support.office.com/en-us/art...3-c8ae6d2b276e
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thanks CK76, the dynamic named range will work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks