Forum Discussion

Copper Contributor

Jun 04, 2020

EXCEL FORMULA HELP

Hello, I am trying to count headcount but cant seem to count unique values. example: Below is the text that i need a countif headcount and i cant seem to get unique values. If there are dupli...

Formulas and Functions

office 365

hurshie

Copper Contributor

Jun 04, 2020

Jos_Woolley

THank you I was trying to use Countifs!

Jos_Woolley

Iron Contributor

Jun 04, 2020

hurshie

=SUMPRODUCT(0+(B$2:B$11=D2),1/COUNTIFS(A$2:A$11,A$2:A$11&"",B$2:B$11,B$2:B$11&""))

=SUM(IF(FREQUENCY(IF(B$2:B$11=D2,MATCH(A$2:A$11&"",A$2:A$11&"",0)),ROW(A$2:A$11)-MIN(ROW(A$2:A$11))+1),1))

Both of these will handle blank cells within the range A2:B11.

Regards