Forum Discussion
Adding a value that is anywhere on a worksheet based on a word in the cell above the value.
Hi Everyone, I am creating a scheduling tool. With this tool I am adding hours based on the position the worker is doing. I have drop down menus set and when the down drop position is populated I...
Hey Scott-
Can you please provide a small non-sensitive example of the way your data is represented so the community can better address your scenario. Sometimes it's a little easier to create a solution with a little visual aid.
As you can see, Bob is doing 3 different jobs over the next 3 days.
I would like to automatically add Bob's and others different positions hours to the top row.
I hope that helps.
The way you have your data structured you will probably want to use SumProduct(). Please see attached .xlsx file for reference.
For Example:
=SUMPRODUCT(($B$10:$G$18="E&M")*($B$11:$G$19>0),$B$11:$G$19)*24