R reachkiran03 New Member May 21, 2013 #1 How to add numbers entered in column and sum it up in excel sheet/ Like 2+3 =5
SirJB7 Excel Rōnin May 21, 2013 #2 Hi, reachkiran03! Assuming you entered your data in column A from cell A2 in advance, you should try this: a) For 2 values, enter in any cell this formula: =A2+A3 or: =SUM(A2:A3) b) For 20 values, you could either use both methods but it's easier the last one: =SUM(A2:A21) Regards!
Hi, reachkiran03! Assuming you entered your data in column A from cell A2 in advance, you should try this: a) For 2 values, enter in any cell this formula: =A2+A3 or: =SUM(A2:A3) b) For 20 values, you could either use both methods but it's easier the last one: =SUM(A2:A21) Regards!
Hui Excel Ninja Staff member May 21, 2013 #3 If your cells are not contiguous you can also use: =Sum(A2, B3, D17) etc which will add A2, B3 and D17
If your cells are not contiguous you can also use: =Sum(A2, B3, D17) etc which will add A2, B3 and D17