help in IF condition

[mwvirk]

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

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

 

[Andrew Poulsom]

Try:

=SUM(COUNTIFS(Q4:Q230,{"ABC","DEF"},X4:X230,"ding"))

 

[mwvirk]

@Andrew Poulsom:
thnx for ur help. yes its working.