the formula you came with kinda helped, but unfortunately you don't know where exactly on the whole array of each week (Example N8: N679), your value is going to be found (For Example: "Person 1"), and if you do not know this, and you cannot reference a cell where this value is...
Count Occurrences of a Specific Value in a Delimited String or Array Count rows in a filtered tablix Count the number of rows in a row group within a matrix with both row groups and column groups CountDistinct with condition? CountIf Expression for Report Builder 3.0 Create a link to open ...
Cell E2: Item Count, Cell F2: Frock Girls, Cell G2: T-Shirt, Cell H2: Capri. In cell F3, the formula for calculating the total number of Frock Girls is: =COUNTIF(C:C,"Frock Girls") - the result should be 3. In cell G3, the formula for calculating the total number of T-Shi...