I'm a newbie but i have posted this once before. The answer I received worked with with the spread sheet snippet but not the full sheet.
I would like to place a formula in all the cells of columns O,AD and AS which would sum the sub-totals in the adjacent columns. The ranges of these sub-totals is as defined by the red 's' and red 'f ' in columns D,S and AH.
I hope the file GSC 2012 bookings is attached.
There is no urgency with this.
thanks in advance for any help.
Hi buffbill,
See the attached file where I have applied the required formula and highlighted it with yellow. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Unfortunately when I copy that formula up and down from the cell it is entered into, the same sum appears in all the cells above and below it----when I want it to show zero until I enter some new data when it should sum the new values appropriate to that booking. Could this be corrected?
Hi buffbill,
May be your are ignoring the sum condition... formula will add the values from "s" till "f"... and this is what formula is doing.
Try shifting "f" little down and fill out the corresponding values, you will find that formula is automatically updating and summing up the new values. Hope this helps.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Also, if you want the formula to appear only when you enter "f", then update that as shown in column AS in yellow in the attached file. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
@DILI,
Other pairs of (s,f) may appear up and below of current position.
Simply that to find if current row has "s", to match first "f" and use OFFSET, else returns "blank"
In O20:
Copy up and down an accross to AD,AS column.=IF(D20="s",SUM(OFFSET(N20,,,MATCH("f",D20:D$163,0),)),"")
Hope this help!
Click the star icon in left-corner of my post if you find my post userful!
Quang PT
quangphanidico@yahoo.com
PM me: Y!M: quangphanidico
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks