SIMPLE TASK-ADDING values from 2 columns in to a 3rd column.

Copper Contributor

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.?

 

2 Replies

@Chelnak 

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.