troubleshooting Question

Using a Different Worksheet for Numbers and Not Copying Some Cells

Avatar of coreybryant
coreybryantFlag for United States of America asked on
Microsoft OfficeMicrosoft Excel
6 Comments1 Solution331 ViewsLast Modified:
In a workbook, I have Prices and CNP (plus more)

On CNP, I basically need the total of Prices Values: ($6.63)
=SUM((A16*D3)+(A16*E3))
(I did this on the same sheet).

And I need to copy this several times one sheet 2 (I am going to rename them - should I do this now).

But I also need to copy this.  When I copy this, it is ($7.25):
=SUM((A17*D4)+(A17*E4))

-or-

if that is not possible, (how) can I copy cells but keep certain cells the same (on the same worksheet)?

For example, D/E16 (merged)
=SUM((A16*D2)+(B16*E3))

and D/E17 should
=SUM((A17*D3)+(B17*E3)

But if I copy it, I get:
=SUM((A17*D4)+(B17*E4))


Is there a way for Excel to copy some of the data?  

I will have about ten work sheets in this workbook.

I could put everything on the same worksheet if necessary /easier, but I rather not.

Thank you
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros