I have a question about using autofill. I have a series of rows that contain
a final cell with a function =sum(I8*J3) and I would like to use the
autofill. however, I only want the "I" column name to change - all of the
cells should reference whatever the "I" column is but J3 should remain
constant throughout.

Whenever i try to autofill both the I and J references increase. I tried
setting the forumla for two cells and then highlighting them both to fill the
series, thinking the pattern had been established. But the J references
increased again, but only every second cell. (It showd J3 for the first two,
J5 for the next two, J7 for the next two, etc.)

Any help that anyone can offer would be greatly appreciated.

Thanks!