Snasui Excel Forum

Hi Dear,

Can we get a count of only distinct values by formula? same like option in pivot, but want to do this by formula?

Thanks

The answer of Absent should be 2, Karim and Ahsan. Why your correct result is 1?

Oop sorry

The formula in G10 could be:

=SUMPRODUCT((($A$2:$A$28=F10)*($E$2:$E$28="Absent"))/COUNTIFS($A$2:$A$28,$A$2:$A$28&"",$C$2:$C$28,$C$2:$C$28&"",$E$2:$E$28,$E$2:$E$28&""))

Thank you