Ask Question

What is the formula equivalent of the function = SUM (B1:B5) ?

=B1+B5

=$B$1+$B$5

=B1+B2+B3+B4+B5

=$B$1+$B$2+$B$3+$B$4+$B$5

=$B1+$B2+$B3+$B4+$B5

+1
Answers (1)
  1. 20 December, 17:11
    0
    The method

    =SUM (B1:B5)

    means sum the cells from B1 through to B5

    so:

    =B1+B2+B3+B4+B5
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “What is the formula equivalent of the function = SUM (B1:B5) ? =B1+B5 =$B$1+$B$5 =B1+B2+B3+B4+B5 =$B$1+$B$2+$B$3+$B$4+$B$5 ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers