Query on Use of Absolute References

[golf4]

Hi, everyone -

I was hoping for a little help on the use of Absolute References. I
have a date entry sheet, in one of my projects, where the data entry
cells ties into a second worksheet. The name of the data entry sheet
is DATA ENTRY-HOURS.

In my 2nd worksheet, I'm using a SUMIF formula to tie the cells in the
two worksheets together. For example, within cell C8 in Worksheet 2, I
have the following formula: =SUMIF('DATA
ENTRY-HOURS'!$B$5:$B$200,1,'DATA ENTRY-HOURS'! C5:C200 ). In Worksheet
2-cell C9, I have =SUMIF('DATA ENTRY-HOURS'!$B$5:$B$200,1,'DATA
ENTRY-HOURS'! D5200 ). The cells in Worksheet 2 C10...C45 are tied
to the data entry sheet using the same formula with the progression of
E5:E200, F5:F200........ while using the absolute reference
$B$5:$B$200.

My query is the following: is there an easier way to copy and paste
the SUMIF formulas in the rest of the cells in Worksheet 2, with the
apporpriate progression, without having to manually change the
forumals in each cell?

Thanks for the continued assistance.

Golf4

 

[Paul Corrado]

Substitute

OFFSET(C1,0,ROW(A1)-1,200)

for the range C5:C200 in your first formula and copy down.

 

[golf4]

Thanks, Paul - I'll give it a shot.

Golf

Substitute

OFFSET(C1,0,ROW(A1)-1,200)

for the range C5:C200 in your first formula and copy down.