You're talking about absolute versus relative references. Absolute
references anchor the reference and don't change it as the formula is copied;
relative references change as the formula is copied.

In your example, if you want a formula always to sum E1:G1, write it like
this: =SUM($E$1:$G$1) The $ signs indicate absolute references; E1:G1 is a
relative reference.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"rmmshost" wrote:

Hi,

I'm not even sure how to describe this problem, so bear with me ;-)

Here's a (hopefully) clear example of what I'm trying to do:

I'm working with 6 columns of data which are divided into groups of 3, so
there is data in A1:C1 and E1:G1. In cell I1, I sum A1:C1 and THEN I copy
over this formula to the next cell, J1, because I want to sum the other 3
cells, E1:G1.

Here's the issue: When I copy over the formula from I1 to J1 (one column)
the cell reference in the formula also moves only one column and ends up
trying to sum B1:D1. Of course, this is working as it should but I really
need to find a way to make the cell reference refer to E1:G1 when I copy it
over. (By the way, I'm providing this extremely simplified version for
demonstration purposes.)

Can anyone help with this? Let me know if you need any clarifications on
what I'm trying to do.

Thanks!