Duplicating Formulas within Worksheet

Hi,

I am trying to duplicate this formula =SUMIF(Sheet1!B38:G38,Total!B2,Sheet1!B39:G39), within a range of cells B19 through AF19. If I click and drag, the formula changes from one cell to the next. How can I control this variable?

Please let me know!

Thank you.

Use dollar signs. The following will keep everything constant except B2 as you don't specify what you want.

=SUMIF(Sheet1!$B$38:$G$38,Total!B2,Sheet1!$B$39:$G$39)

Originally Posted by StephenR

Use dollar signs. The following will keep everything constant except B2 as you don't specify what you want.

=SUMIF(Sheet1!$B$38:$G$38,Total!B2,Sheet1!$B$39:$G$39)

Freaking awesome! I love this forum! I've wondered the same thing!

And I used to think I knew so much about excel.