Excel formula to count non empty cells in a column for distinct values in an other column-CodePudding

Home > database > Excel formula to count non empty cells in a column for distinct values in an other column

Excel formula to count non empty cells in a column for distinct values in an other column

Time：02-11

I have a list of members in Excel with their date of deaths (date of death not populated, if member is still alive). For one member there can be more lines because there can be more benefit lines associated. I would like to count the number of distinct members who are dead.

=SUMPRODUCT((A2:A9&B2:B9<>"")/COUNTIFS(A2:A9;A2:A9&"";B2:B9;B2:B9&"");--(B2:B9<>""))

Page link：https//www.codepudding.com/database/296682.html

Prev:Return a yes or no if a value is matched on another column on a different sheet

Next:Find columns where week row and year row matches values given in another cell range

Tags：

excel

count

Links：
CodePudding