Question

Which is the correct formula to add the values in cells A1 and B1?

Answer 1

If you open Excel and you type 5 into A1 and 5 In B1, click on C1 and then auto sum , if you look at the top it will show =SUM (A1+B1) after you click enter, your total of 10 will automatically pop up in C1

Answer 2

I'm assuming you are referring to Excel. There are a few ways to add A1 and B1.

First you could use '=SUM(A1+B1)'

You could also use '=SUM(A1:B1)' which adds the values of all the cells between A1 and B1, but since they are next to each other, this would work.

You could also use '=SUM(A1,B1)' where you list all the cells you want to add with commas in between.