Hello. How can I write one formula and drag it across a row so that it will add one row for each sum formula, for each column I move to the left with the formula.
Example:
=SUM(D41:D42)/SUM(C41:C42)
==SUM(E41:E43)/SUM(D41:D43)
=SUM(F41:F44)/SUM(E41:E44)
I want to drag the original formula across a row.
It looks like you're also changing columns. Is that intentional?
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
If you include de $ sign the referenced part to the right in this case the starting row number will remain the same-...
Please Login or Register to view this content.
Something like this might work for you:
Enter where you want and fill across:
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Oops, forgot the division!!
This should do it:
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 09-01-2015 at 07:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks