Help correctly editing this dynamic array formula needed please

[Preston1983]

I really need help please to edit this formula:

=IFERROR(TEXTJOIN(", "&CHAR(10),TRUE, SORT(FILTER(talent[Employee],(talent[What]=G$9)*(talent[How]=$D6)*(talent[Department]=$G$3)))),"")

So it counts the total number of employees that meet this criteria, rather than listing the employees by employee number. I've tried and tried and failed to get it to work. I need to be able to apply it a much larger data set so showing each employee number isn't going to work.

Thanks!

 

[awoohaw]

Please provide some sample data (anonymized). You can also get the xl2bb add in to make it easier for people to help you.

XL2BB - Excel Range to BBCode add in

 

[Fluff]

How about

=ROWS(FILTER(talent[Employee],(talent[What]=G$9)*(talent[How]=$D6)*(talent[Department]=$G$3)))

 

[Preston1983]

How about

=ROWS(FILTER(talent[Employee],(talent[What]=G$9)*(talent[How]=$D6)*(talent[Department]=$G$3)))

Sadly not. Will send a file tomorrow to make understanding it easier. I'm not the best at explaining excel.

 

[Fluff]

Ok