I have a sheet that has a column called Steps, Values Step 1, Step 2,...Step 10
From another sheet, I want to count how many Steps happen in a Stage (which contains a number of Steps)
I would like a count formula that looks at the Steps in each Stage and counts how many rows in the other sheet have those Steps in it. I need to be able to edit the table that assigns the Steps to the Stage.
I realise that I could hard code a number of countifs for each step but I would like to have it user editable as a table above.
So for example, Stage 1 would be a count how many rows have either Step 1 or Step 2 in the Step column on the related sheet.