Forum Discussion

AB_15's avatar
AB_15
Copper Contributor
Jun 10, 2023
Solved

Count with 2 criteria in one range per row

Greetings!   Specification: Excel 2016, Win10.   Context: person has # X and # Y. There are multiple persons with different XY's. It is possible for the numbers to be exactly the same in XY.    ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 10, 2023

    AB_15 

    =COUNTIFS($B$2:$B$6,32,$C$2:$C$6,56)

    You can try COUNTIFS.

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 10, 2023

AB_15 

Or if you want to check the complete table use a pivot table.

X and Y in rows area, Name in values area.

 

Resources