Apologies if this is rather obvious, but I’m having some trouble getting my head around the filter formula.
I’m attempting to make a simple summary table from a larger detail table - and pull in some specific data.
See this screenshot :
What I am trying to do is add up the “Task Est Duraction” column in the Workflow Master Table, but only add up rows where the Project stage is the one listed in the summary table.
In this instance, I’m trying to come up with a formula that adds up 2,3,4,5 & 6 inside the master table.
Eventually, I need to extend it to check the first column as well (SN101) - as each episode will have its own list of tasks and times. ie, my summary table will look something like this
To put it another way : I want it to sum only a subset of the column called “Task Est Duration” - using only rows from the master table where the data in the episode and stage columns match those in the summary table.
I have spent ages in the help docs, and tied so many different iterations of the formula. (I feel like formats have changed since some of the help docs were written)
Any help is as always much appreciated. Thanks!