Include an OR statement in a count if

[marcvanderpeet12]

Dear all,

I have a case where I need an count if statement that performs a count when criteria a and b is met. In the attached example I would like to perform a count IF the column A is "apple" or "apples". Any feedback on how I should do this?

kr,
Marc

 

[Fluff13]

How about
=SUM(COUNTIFS(Table1[Fruit],E2:E3))

 

[bosco_yip]

Or,

=COUNTIFS(Table1[Fruit],E2&"*")