i'm looking for 2 words in 1 row and then checking another row and looking for another word. if both rows contains specified word then i should get the total.
using the following IF condition - but it can read only 1 word in 1 row
in Q4:Q230 i want to find these word:
ABC
DEF
then it should check X4:X230 and seach for word:
ding
if both row contain true condition then i should get the total.
help pls.
using the following IF condition - but it can read only 1 word in 1 row
Code:
=COUNTIFS(Q4:Q230,"ABC",X4:X230,"ding")
in Q4:Q230 i want to find these word:
ABC
DEF
then it should check X4:X230 and seach for word:
ding
if both row contain true condition then i should get the total.
help pls.