Which inbuilt feature calculates the sum of data arranged in contiguous rows or columns?
SUM
AUTOSUM
Count
all of the above
Answers
Answered by
2
Explanation:
Sum function!! maybe
hope it helps you!
have a great dayy!
Answered by
1
Answer:
options 1st
- Sum every n rows down in Excel with formulas
- Enter this formula into a blank cell where you want to put the result: =SUM(OFFSET($B$2,(ROW()-ROW($B$2))*5,0,5,1))
- Tip: In the above formula, B2 indicates the started row number you want to sum, and 5 stands for the incremental row numbers.
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here's an example.
Similar questions