Formula in b23 to drag right and downwards
the math needs to be
horizontal running total divide month (helper added ) to get average
after getting this divide average 2013 ( needs fix cell I guess )
The horizontal total would like this I guess =SUM($B2:B2)
I didn't know this , I got from down here from our respected experts
Within one formula , I tried , I was almost there ,
the formula hanged on some brackets I did not know
to close correctly
Re attached the maths with the expected answers using
long method , my last math was wrong I guess
need that within 1 formula to drag right and down for compute all sellers
Anyone , need close a report to carry to work tomorrow
Not sure 1 formula refers to what and how?Originally Posted by makinmomb
Please explain with cell/ range references for giving exact solution
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Find attached file , explanation attached
In B23 Cell
=IFERROR(((SUM($B2:B2)/B$22)-INDEX($J$2:$J$8,ROW(A1)))/INDEX($J$2:$J$8,ROW(A1)),"")
Drag it down and right....
Refer the attached file for details
Yes that is it , though I think a simple
formula would also be available
I will take it though keeping the thread
still open
Looking for formula with the normal BODMAS
combined with running total formula SUM($B2:B2)
I shall mark the thread solved , and start
another one , since the formula serves me
purpose but I am looking for a modified simple
one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks