Mar 27 2022 12:26 PM
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.?
Mar 27 2022 12:31 PM
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.
Mar 30 2022 01:55 PM
Thanks@Hans Vogelaar . I figured it out.