Hi all,

I am trying to solve this problem for quite a long time, but no idea what's
wrong. My problem si a typical one. I need to use COUNTIF function with more
than 1 criteria.
I already tried SUM function (as array formula) or SUMPRODUCT, but result is
0, which isn't correct.

My criterias are CriteriaA:(Range A="string*") AND CriteriaB:(Range
B="string*"). I suppose, that above mentioned functions, can't work with
criteria 's expression "string*", but I am not sure about it.

Have you got any idea how to solve it?

Is there any possibility to write formulas whe
SUMPRODUCT(((CriteriaA1)OR(CriteriaA2)OR(CriteriaA x))AND((CriteriaB1)OR(CriteriaB2))) ?

Many thanks in advance for any tips.