Count, and related values

Occasional Contributor
Hi, I have reported includes number of unique tasks how can I get summary of information related to eash task for example how many certain tasks occurs, how many tasks performed by each user, average TAT for certain task.
2 Replies

@Khalil600 

=COUNTA(UNIQUE(FILTER($A$2:$A$16,$C$2:$C$16=E13)))

=SUMIF($A$2:$A$16,E5,$B$2:$B$16)/COUNTIF($A$2:$A$16,E5)

 

Maybe with the above formulas as shown in the attached file. The first formula works if you use Excel online or Office365 or 2021.

Thanks Quadruple_Pawn, I'll try it and let you know.