Hi guys,
I have been looking all day long for a single formula (may be a big one) to sum multiple values witch depend on the adjacent cell but i'm not making a lot of progress. I hope you can help me.
Like you can see in the file, there is a complete array of data to the right and i have to make some calculations on the left.
Now, i'm looking for a formula witch will sum all the numbers to the right adjacent cell of "OT". But there are a few tricky things.
- The layout can NOT be changed.
- "OT" will only be written in the first column of the day.
- But "OT" can be written in any of the rows witch are available for each person (e.g. 3 rows for Person 1).
- "OT" can appear multiple times every week.
I hope you can help,
Thanks in advance!!
Bookmarks