Question: Excel Help..... how do I add a formula to each Row item that already has its own data? pic for example. column E3 has formula

Excel Help.....
how do I add a formula to each Row item that already has its own data?
pic for example.
column E3 has formula =sum(E2/$D$2)
that formula has been dragged all the way to the right to Column AG3.
Column E5 has formula =sum(E4/$D$4) all the way to Column AG5
i need to do the same formula to E7, E9 and so forth.
I have about 1000 rows.
Excel Help..... how do I add a formula to each Row item

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Excel Project 1 - MS Excel (Spring 2020) Use the following project description to complete this activity (all the details are included in this document, in the 22 steps below) For a review of the...

Q:

I'm not sure how this needs more info in case an "expert" says it does this is all the info I am given to complete the assignment. Independent Project 1 - Budget Excel project. Could someone help me...

Q:

Hello wanted to know if someone could help me with an Excel assignment. Personal Budget Exercise - MS Excel Use the project description HERE to complete this activity. For a review of the complete...

Q:

need help don't know excel. thank you. Personal Budget Exercise ? MS Excel Personal Budget Exercise - MS Excel Use the project description HERE to complete this activity. For a review of the complete...

Q:

Waren Sports Yearend Worksheet Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks....

Q:

Waren Sports Yearend Worksheet Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks....

Q:

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Q:

I have this Accounts assignment that needs to be done. Need help on that Statement of individual work Individual work required This project is designed to assure that all students, individually, have...

Q:

Personal Budget Exercise - MS Excel Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then...

Q:

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Q:

The automobile has about 5,000 parts. How many parts does a typical mountain bike have? Which of these parts would be synchronized in delivery to final assembly?

Q:

Define nonmanufacturing costs.

Q:

When the Internal Revenue Code uses the word "solely," it really does mean "solely" in which of the following contexts? A . Section 3 5 1 B . Section 3 6 8 ( a ) ( 1 ) ( B ) C . Section 3 6 8 ( a ) (...

Q:

Problem 4: [20 marks] Simulate the movement of an elevator (filename: Elevator.java ) Design an algorithm and then write a program called Elevator, which models a simplified elevator. The elevator...