I'm needing a formula or code that will allow the following to happen if possible.
- First search column C for a value (Wk1,Wk2,Wk3,Wk4 or Wk5)
- then show the sum of column O In cell X15
- the formula should only sum the column up to the point Wk 2 shows in Column C
Something to note is that Column C will have a dropdown menu in each cell so the user can select when Wk1 or Wk2 etc starts so these values can move around rather than being a fixed distance apart.
Hope this makes sense and the sample image shows but if not please let me know and I'll do my best to explain further.
Thanks in advance.