User Profile
kirkBolton
Copper Contributor
Joined Nov 22, 2020
User Widgets
Recent Discussions
Re: How to assign hidden values to specific text in my dropdown data validation that is later sum
mtarler Your solution using =SUMPRODUCT(XLOOKUP(D28:J28,$AB$4:$AB$22,$AC$4:$AC$22,0,0)) worked perfect. Thank you and thanks to everyone. I have learnt so much from the community. I am so grateful for this resource and the skills of you guys. Thanks5.7KViews0likes0CommentsRe: How to assign hidden values to specific text in my dropdown data validation that is later sum
Hi Hans, thanks for your feedback. I accidentally sent you a blank form. Please find attached a copy of the form using both the initial formula you provided and your most recent formula. Your most recent formula is used in the yellow highlighted cells. I am not getting the results of the shift code value using the new formula you provided. In blue highlight is the use of your initial formula but it's not giving the correct corresponding value for the shift code. I would greatly appreciate your assistance in resolving this issue. I can't understand why the values for the corresponding shift code is giving a different result. THANKS AGAIN.5.8KViews0likes7CommentsRe: How to assign hidden values to specific text in my dropdown data validation that is later sum
Greetings Hans, thanks again for the solution. I'm now realizing that some of the assigned cells are not giving the results. So some works and some doesn't. Do you know what might be causing this. Maybe I can send you the form to look at. I'm going to send you the file. The results are not posting for some of my staff codes5.8KViews0likes9CommentsHow to assign hidden values to specific text in my dropdown data validation that is later sum
How to assign hidden values to specific text in my dropdown data validation that is later sum. I have been trying to figure out a solution to the above where I can create a work schedule that when I add a work shift code, for example S1, then it would be representing 8 hours of scheduled work hours and S2 to represent 4 hours of scheduled work then when I total the 2 cells then I'm suppose to get 12 hours. I know how to create the drop down, just don't know how to assign the hours to each work shift so when I'm summing those cells it is read as numbers even though text is visible. ThanksSolved6.4KViews0likes13Comments
Recent Blog Articles
No content to show