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.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 10, 2023

AB_15 

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

You can try COUNTIFS.

Resources