Thanks Dave

With your help finally I finished my work

"Dave F" escreveu:

You can use SUMPRODUCT: =SUMPRODUCT(--(A1:A10="Joe"),--(B1:B10="Yes"))

You can't use SUMIF with multiple criteria. You could use COUNTIF if you
were to concatenate columns A and B and do the COUNTIF off that column of
concatenated text strings, as suggested by the other person to respond.

Dave
--
Brevity is the soul of wit.


"Ricardo" wrote:

Hi all

I need your help. i need to use the countif but with two criterias ...
something like the sumproduct and the sum if.

Example:
Col. A Col. B
Joe Yes
John No
John No
Joe Yes
Joe No

I need to count how many Joe with Yes I have.

Thanks,