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 would like to add the hours that are in the cell below the populated cell to a main cell.
Example "Worker" cell is throughout the whole worksheet (as many as 200 times) and the time value below this cell could be 3 hours through to 8 hours.
There is a total "Worker" hours cell at the top of the worksheet which I would like to add all these individual "Worker" hours together.
I'm not sure if it is a IF or a IFSUM formula.
Thank you,
Scott
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.
