Now press Alt+= or click the AutoSum icon. Select cell A1, press Shift, and select cell K11. Select the range of data, including the empty rows and columns surrounding the data A1:K11 (see screenshot).Ī quick technique for selecting data without using the mouse: Like C:C when input numbers are in the Z column. Here the whole column isĬolumn numbers are indexed as A, B, C goes on. Like you can use SUM, COUNT, MAX function but cannot use AVERAGE or MIN function In Excel, working with array reference and need to access the whole column where you know empty cells are not interrupted. In this article, we will learn How to Sum values in vertical and horizontal ranges in Excel.
0 kommentar(er)
