I’ve seen a number of SUMPRODUCT based workarounds, but they don’t seem to allow me to use TableName[ColumnName]?
I have a table that is the result of taking data from 3 source tables, which is then heavily filtered (multi column filtering, c. 2000 down to c. 750 records) to only display the records required (and before you ask, PowerQuery doesn’t do it because sometimes I need to unstack the filtering so cannot loose the filtered records) …
I have 2 columns (EmailAddress and TrainingCompleted) that I want to use to derive a % …
EmailAddress is easy because it’s email addresses so I can use =SUBTOTAL(103, Table1[EmailAddress]) …
But TrainingCompleted is a problem because it contains ONLY ”TRUE” or “FALSE” which are the result of an ISNUMBER based formula so =COUNTIF(Table1[TrainingCompleted], “TRUE”) picks up filtered AND non filtered rows …
Is there a way I can get a total of the number of rows with “TRUE” in TrainingCompleted, but only the filtered rows?
Thanks …
I have a table that is the result of taking data from 3 source tables, which is then heavily filtered (multi column filtering, c. 2000 down to c. 750 records) to only display the records required (and before you ask, PowerQuery doesn’t do it because sometimes I need to unstack the filtering so cannot loose the filtered records) …
I have 2 columns (EmailAddress and TrainingCompleted) that I want to use to derive a % …
EmailAddress is easy because it’s email addresses so I can use =SUBTOTAL(103, Table1[EmailAddress]) …
But TrainingCompleted is a problem because it contains ONLY ”TRUE” or “FALSE” which are the result of an ISNUMBER based formula so =COUNTIF(Table1[TrainingCompleted], “TRUE”) picks up filtered AND non filtered rows …
Is there a way I can get a total of the number of rows with “TRUE” in TrainingCompleted, but only the filtered rows?
Thanks …