none
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.

    Example

    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.

    Ahmed

    Wednesday, October 3, 2018 7:44 AM

Answers

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

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

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

All replies