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

=B1+B2+B3+B4+B5

The SUM function in Microsoft Excel is used to add two or more than two cells. The SUM function, one of the math and trig functions, adds values. We can add individual values, cell references or ranges or a mix of all three. The syntax is SUM(number1,[number2],...). Since the given function is showing SUM(B1:B5) so it means that add the cells from cell B1 to B5. So we can write as B1+B2+B3+B4+B5