AVERAGEB4B54 which would give me the average of the cells from B4 to B54 but I want to reference the whole B column. Then press Ctrl Enter ie. To add up an entire column enter the Sum Function.
Select entire column including blank cells except header with define name If the list contains blank cells with the shortcut cannot solve the selecting now you can define a name for the column that you can select it except the first row in Excel.
Both the Excel and VBA methods make use of the COUNTIF function and selecting an entire column with the asterisk sign as the criteria to count cells from a single column that contain text. That little black square is called the fill handle. Click Formula Define Name see screenshot. Or when the cursor changes to the skinny plus sign left click and hold grab the fill handle then just drag down the column to the end of data and the formula will be copied.