All you want to calculate the sum of the first cell of the column to a specific cell number be the last column
The sense that if you select the first cell of the collection is determined based on the last column number, which is placed in the cell "K2"
Not sure I understand your request completely, but try this...
=SUM(OFFSET(D5,0,0,1,K2))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Genius solution and wonderful
Thank you very much, Mr. "Ford"
God bless you
Last edited by shimaa01234; 01-07-2015 at 11:08 AM.
or this
=SUM(D5:INDEX(D5:O5,$K$2))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Mister "Alekay"
You always wonderful your solutions wonderful and distinctive
Thank you very much sir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks