I am setting up a worksheet to count the same data range but for various
people. Example
I am using the SUMPRODUCT function to add C1:C100 IF D1:D100=DENISE AND
C1:C100=X.
I would like to use the exact same data range but add for RYAN instead of
Denise. I have Ryan set up in his own column but when I copy and paste the
formula from Denise's column, it moves the ranges; C1:C100 becomes C2:C101
AND D1:D100 becomes E1:E100 or something similar to that... it varies
sometimes and I'm sure it's because of how I am copying, etc.

Any help would be greatly appreciated as it's getting to be more trouble
than it's worth to go in and change each formula for each cell.

Thanks!