When just starting out people often find themselves wondering how to add a whole column in Excel. Usually, a formula only applies to a range of cells, not the entire column.
This is actually really simple to achieve and I will show you two quick methods on how to do it: one with a formula, the other using Excel's Status bar.
In the example shown, the formula in D2 is
=SUM(B:B). This sums up all values from column B.
If you need additional info, I also wrote an article on how to use SUM function in Excel.
The second option is to use the Status bar. This is useful when you just want a quick glance at the total sum of values, rather than actually calculating the sum using a formula.
Note: Be careful when referencing an entire column. While it may be useful to include all values in your formulas, this approach is prone to errors. If you accidentally insert a value anywhere in that column, it will be added to your result.
I hope this article showed you exactly how to add a whole column in Excel. However, in case you still have questions, don't hesitate to reach out.