USING COLUMN NAME TO SUM SPECIFIC DATACOLUMN IN EXCEL

Stop selecting columns cell by cell in Excel.

In this video, I show you a smart Excel trick that allows you to choose and sum only the specific columns you want from your dataset without clicking column after column.

Instead of using confusing cell references, you will learn how to work with column names, making your formulas easier to read and reducing mistakes when working with large datasets.

This method is perfect for students, beginners, and professionals who want to work faster and smarter in Excel.

What you will learn in this video:
How to sum specific columns without selecting cells one by one
How to use the Create from Selection tool in Excel
How to turn column headers into Named Ranges
How to write formulas using column names instead of cell references

STEPS:

1. Select your table: Highlight the entire data range, including the headers.

2. Go to Formulas tab: Navigate to the top ribbon and click on "Formulas."

3. Click "Create from Selection"

4. Tick Top row: In the popup box, ensure only "Top row" is selected, then click OK.

5. Position your cursor: Click the cell where you want the result to appear.

6. Enter the formula: Type your formula using the column names (e.g., =ENG+CHE+PHY) and press Enter.

7. Apply to all: Use the fill handle to drag the formula down for the rest of the rows.

If you want to stop wasting time selecting cells manually and start writing clean and professional Excel formulas, this video is for you.
Like the video, subscribe for more practical Excel tutorials, and share with anyone learning Excel.

#Excel
#MicrosoftExcel
#ExcelTips
#ExcelTutorial
#ExcelForBeginners
#LearnExcel
#ExcelFormulas
#DataAnalysis
#SpreadsheetTips
#OfficeSkills
#video
#shorts

Видео USING COLUMN NAME TO SUM SPECIFIC DATACOLUMN IN EXCEL канала Jojo Tech Man