Count if when condition met RRS feed

  • Question

  • Hello everyone. 

    I need your help. I need to count cell with a specific character "O" in a range Only if the cell containing that character is met another character in another range.


    The count formula will be in cell AH4, to count all cells in range C4:AG4 containing "O" if the cells in range C3:AG3 contains "FR" or "SA"

    The formula need to be dragged down across rows.

    Thank you in advance.


    Wednesday, October 3, 2018 7:44 AM


  • =SUM(COUNTIFS($C$3:$AG$3,{"FR","SA"},$C4:$AG4,AH$3))

    Regards, Hans Vogelaar (

    • Marked as answer by Ahmed Morsyy Wednesday, October 3, 2018 11:03 AM
    Wednesday, October 3, 2018 8:36 AM

All replies