Attached is a example of what I need help with. I want a excel formula to look off of a certain Line and use text to calculate sume of values. Attachment will help.. thanksExcel Help.xlsx
Attached is a example of what I need help with. I want a excel formula to look off of a certain Line and use text to calculate sume of values. Attachment will help.. thanksExcel Help.xlsx
Simple sumif would suffice the purpose
if this solves your query mark thread as solved and if you like the answer click " * " add rep icon in the bottom left corner of post
hey that looks good. except on the sum range I do not want to have it set, as I might change what cell Total L10, Total L20, Total L30 are. Is there anyway is can be automated?
you want to change the location of sum range or just the name from L10 to something else
With this you don't have to change anything on your spreasheet. Just copy and paste this formula in O2 and drag it the right and then down:
=SUMPRODUCT(($A$5:$A$11="Total "&O$1)*($B$2:$J$2=$N2)*($B$5:$J$11))
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
Just to mess around some, this will also work...
=SUMIF($B$2:$J$2,$N2,OFFSET($A$2,MATCH("Total "&O$1,$A$2:$A$11,0)-1,1,1,COUNT($B$2:$J$2)))
NOTE that your "Total L30" has a trailing space, you need to remove that
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks