Count with 2 conditions

[Belleke]

What would be the formula for:
if column A range contains apples and pears then count column c that contains cancelled or pending

Thanks in advance

 

[AliGW]

Do you mean apples OR pears???

 

[Belleke]

Yes,sorry

 

[GraH - Guido]

=SUM(COUNTIFS(A:A;"apples";C:C;"cancelled");COUNTIFS(A:A;"pears";C:C;"cancelled");COUNTIFS(A:A;"apples";C:C;"pending");COUNTIFS(A:A;"pears";C:C;"pending"))

 

[Belleke]

See attached. I am stuck.

 

[AliGW]

Try this:

=SUM(COUNTIFS(A:A,{"apples","pears"},C:C,{"cancelled";"pending"},B:B,[@Result]))

 

[Belleke]

Thank you,works perfectly.

 

[AliGW]

You're welcome.