formula to add the cells A1,S3, U2
Answers
Answer:
In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
Answer:
Type =SUM in a cell, followed by an opening parenthesis (.
To enter the first formula range, which is called an argument (a piece of data the formula needs to run), type A2:A4 (or select cell A2 and drag through cell A6).
Type a comma (,) to separate the first argument from the next.
Type the second argument, C2:C3 (or drag to select the cells).
Type a closing parenthesis ), and then press Enter.
Each argument can be a range, a number, or single cell references, all separated by commas.
=SUM(A2:A4,2429,10482)
=SUM(4823,A3:A4,C2:C3)
=SUM(4823,12335,9718,C2:C3)
=SUM(A2,A3,A4,2429,10482)
Tip: If you need to sum columns or rows of numbers next to each other, use AutoSum to