Ask Mac Questions and Get Answers from Experts ASAP
Are the values in column A and B numbers or text. If they are numbers do you want to add them arithmetically?
Ok assuming the data starts in row 2, type this formula in cell C2
Next select cells C2 through C100 (or the last row of data), and press Ctrl + D to copy the formula down to the last cell in C
Hope this is ok. Let me know if you have any questions
No problem. I will prepare now a sample file with the formulas and send it to you, You can pick it up when you log in here in the morning
Ok here is a sample file with the formulas in the yellow cells. You can copy the formulas down to as many rows as you like
Have a look and let me know if you have any questions