Hi all, I am trying use INDEX a range (J40:AR40) to prevent a macro that deletes columns in that range so it doesn't cause formula REF errors. The macro deletes a range of columns between J40:AE40. I have tried every possible idea I have on where to place the INDEX's but with no luck. Any help would be greatly appreciated.
Thanks
Please Login or Register to view this content.
Alex
It's probably not the formula, but the Macro you need to correct...
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Try this...
PHP Code:=IF(C40="REMOVE",SUMIF(INDIRECT("$J$39:$AE$39"),"Extended Price",INDIRECT("J40:AE40"))*-1,SUMIF(INDIRECT("$J$39:$AE$39"),"Extended Price",INDIRECT("J40:AE40")))
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
This formula works great but, I have multiple rows with this formula and I cant fill it down. Any suggestions?
Thank you,
Just applying the suggested formula above and down won't affect the logic. Since the ranges were already surrounded by dollar sign so it denotes that the range wont get incremented / decremented.
Please correct me if my assumption is wrong
I am using the dollar signs to set the Range ($J$39:$AE$39) for my criteria ("Extended Price") in my sumif statment. I need the sum range (J40:AM40) to be incremented to continue down the rows... if that makes any sense.
Thanks
Hm.. Now I understand....
Try this....
Formula:
Please Login or Register to view this content.
This sort of works... The macro that deletes columns in that range, when run, deletes and shifts the range formula over and eventually causes a REF error.
If that makes sense.
This sort of works... The macro that deletes columns in that range, when run, deletes and shifts the range formula over and eventually causes a REF error.
If that makes sense.
Oops... Posted the formula without testing....
Just confirm me what is the start cell of the formula (i.e.) the cell on which the formula starts
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks