Hello, what is the meaning of at sign @ and dollar sign $ in excel formula ?

For example what is the difference between function =sum(A2:A10) and =sum($A$2:$A$10) ? It looks it gives the same results.

For example what is the difference between function =sum(A2:A10) and =sum($A$2:$A$10) ? It looks it gives the same results.

Hi,

The**at sign** is usually used as **reference to the cell** in the named column at the current row. For example when you want to multiply values in inserted Table 1 with headers Unit price and Units sold:

**=C3*D3** will work the same as **=Table1[@[Unit price]]*Table1[@[Units sold]]**

The**dollar sign** is usually used to indicate **absolute reference**. For example when the formula is moved or copied to other cells and you need to use fixed position of specific cell.

Formula in C7 is**=$B$2+1*B7**. When you will copy it to C8, it will change to **=$B$2+1*B8**, so the rate from B2 is still used, because of absolute reference is set with dollar signs:

When you don't use the absolute reference for B2 and you will copy the formula to C8, it will change to =B3+1*B8, so it will not provide expected correct result.

The

The

Formula in C7 is

When you don't use the absolute reference for B2 and you will copy the formula to C8, it will change to =B3+1*B8, so it will not provide expected correct result.

Related questions

## How to add side by side rows in excel pivot table ?

## Is CSV excel file Comma or Semicolon separated / delimited ?

## How to change the font of equation formula in Word ?

## Check if value exists in column more than once or twice - Excel

## How to show Euro, Dollar or Pound sign on right in Excel ?

## Move excel chart horizontal axis to bottom - below negative values

## Invalid cell reference error in Excel vLookup function - #REF!

## Create two Charts from one Pivot table - add multiple excel charts

## Excel and Word menu tabs & tools in toolbars disabled / grayed out

Trending questions

Remove or hide bottom navigation bar with buttons on Android How to calculate inverse currency exchange rate ? Man Month calculation - how many man days or man hours ? How to add side by side rows in excel pivot table ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? How to calculate how many Man Days are 3 Man Hours ? Samsung Galaxy A & F better than M series ? What's the difference ? Is PLS LCD display good ? Difference between PLS LCD and Amoled Difference between Standard and Vivid screen mode on Android

Remove or hide bottom navigation bar with buttons on Android How to calculate inverse currency exchange rate ? Man Month calculation - how many man days or man hours ? How to add side by side rows in excel pivot table ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? How to calculate how many Man Days are 3 Man Hours ? Samsung Galaxy A & F better than M series ? What's the difference ? Is PLS LCD display good ? Difference between PLS LCD and Amoled Difference between Standard and Vivid screen mode on Android

Find us on Facebook

2023 AnswerTabsTermsContact us