Absolute formulas

I need to sum the values from the top cell and subtract the bottom cell
E2-E3 and then
E2-E4
putting the result in R3 and R4
I can uses the absolute cell for the first column, but now I want
use that same formula in the next column, F and the answers in S

Thanks
IS-126-finish.xls
thebigtableAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AnuroopsunddCommented:
Copy the E cell where you have the formula.

Right Click on the F column where you want to paste the formula.. select Paste special.. and select formula...
0
Shanan212Commented:
=E4-E$2

Place the formula as such (remove the $ sign infront of the "$E$2"

Then you could drag it down/accross for column F
0
thebigtableAuthor Commented:
I need to carry this down the rows for several groups skiping a row evry 6 rows.  This then changes the formula
From E4- to E9-
Not the formula in R3 thru AC3.  For  I am always subtracting the value of the cells under the highlighted cells to give me the difference from the starting point.
So I need to repeat R3 : AC3 down to R8 : AC8

I was hoping this was somethig that could be done programatically.  If not , I can go with the manula route.
sampleIS-126-finish.xls
0
Saqib Husain, SyedEngineerCommented:
Try this formula in R3

=E3-INDEX($A:$P,INT((ROW()-2)/7)*7+2,COLUMN(E$1))

This formula assumes that there are exactly 7 rows for each set.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
thebigtableAuthor Commented:
It worked beautifully!
Many thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.