Help with spill overflowing on formula calculation after pressing enter.

Copper Contributor

Hello, I am new to excel and I have been watching training tutorials for help with the basics and so on. I tried entering my formula, =B4:B8, pressed enter and the total was literally a repeat of all 5 numbers. Can someone help me? I followed all the steps from the video correct. 

1 Reply
Wrap that range in a SUM function.

=SUM(B4:B8)

Kevin