Write in B2 Cell with SUM 3 ROW INDIRECT CONCATENATE 1A21-11 then press Ctrl Shift Enter. Then press Enter to complete the task. All you need to do is press ENTER to confirm it.
Equals sign signals the start of a function Function name a unique identifier which tells Excel which set of formulas you would like to use.
MultiplicationTo multiply values use the operator. All you need to do is press ENTER to confirm it. When multiplying just two numbers a multiplication formula is more straightforward. If you click the SUM or function name it will change o a blue hyperlink to the Help topic for that function.