Forum Discussion
SIMPLE TASK-ADDING values from 2 columns in to a 3rd column.
I am having trouble with a simple task. Adding values in Column X +Column Y in to Column Z. What is the proper formula, what do I highlight, etc.?
Let's say the values start in row 2 (perhaps with headers in row 1).
Enter the following formula in Z2:
=SUM(X2:Y2)
Double-click the fill handle in the lower right corner of Z2 to fill the formula down to cells below.
ThanksHansVogelaar . I figured it out.