Copying Formulas 9-1-1!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 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!
 
This is a Frontpage Newsgroup.
try asking in one of the Excel newsgroups.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
 
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 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!
|
 
Back
Top