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.