Copying Formulas 9-1-1!!!!

[Guest]

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 D1100=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 D1100 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!

 

[Steve Easton]

I think you need to try an Excel news group.

--
Steve Easton
Microsoft MVP FrontPage
FP Cleaner
http://www.95isalive.com/fixes/fpclean.htm
Hit Me FP
http://www.95isalive.com/fixes/HitMeFP.htm

 

[David Berry]

This isn't a FrontPage question. Try the Excel news groups.

 

[Jens Peter Karlsen [FP-MVP]]

This is a Frontpage Newsgroup.
try asking in one of the Excel newsgroups.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

 

[Stefan B Rusynko]

Check the Excel help files for the way to set relative, absolute and mixed cell references

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|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 D1100=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 D1100 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!
|