Help with spill overflowing on formula calculation after pressing enter.

%3CLINGO-SUB%20id%3D%22lingo-sub-2350073%22%20slang%3D%22en-US%22%3EHelp%20with%20spill%20overflowing%20on%20formula%20calculation%20after%20pressing%20enter.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350073%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20new%20to%20excel%20and%20I%20have%20been%20watching%20training%20tutorials%20for%20help%20with%20the%20basics%20and%20so%20on.%20I%20tried%20entering%20my%20formula%2C%20%3DB4%3AB8%2C%20pressed%20enter%20and%20the%20total%20was%20literally%20a%20repeat%20of%20all%205%20numbers.%20Can%20someone%20help%20me%3F%20I%20followed%20all%20the%20steps%20from%20the%20video%20correct.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2350073%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2350079%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20spill%20overflowing%20on%20formula%20calculation%20after%20pressing%20enter.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350079%22%20slang%3D%22en-US%22%3EWrap%20that%20range%20in%20a%20SUM%20function.%3CBR%20%2F%3E%3CBR%20%2F%3E%3DSUM(B4%3AB8)%3CBR%20%2F%3E%3CBR%20%2F%3EKevin%3C%2FLINGO-BODY%3E
Occasional Visitor

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