Microsoft Office Forums - View Single Post - [Solved] The difference between a comma and colon when adding?

Thread: [Solved] The difference between a comma and colon when adding?

View Single Post

Old

03-22-2016, 02:46 AM

Exhale

Exhale is offline

Exhale uses Windows 10

Windows 10 Exhale uses Office 2010 64bit

Exhale uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Mar 2016

Posts: 17

Exhale is on a distinguished road

Default

The difference between a comma and colon when adding?

Sorry for a very simple one but I'm slowly learning Excel...!

What's the difference between these two formulas when I'm trying to add. They seem to do the same thing?

=SUM(A1,A5) and
=SUM(A1:A5)

Reply With Quote