Simple Countif Formula

[kelscot30]

HI guys,

Apologies this is a simple one! Had this formula before but I am getting an error so going wrong somewhere!

Trying to countif column has a name and another column has a yes, basically telling me how many times Tom tagged a YES to a call he made. I have tried a few variations on the below:

=sumif(J:J,"tom")*(L:L,"YES"))

But none of the above work!

Thank you x

 

[NBVC]

If you are using XL2007 or later you can use COUNTIFS

=COUNTIFS(J:J,"tom",L:L,"YES")

else use Sumproduct:

=SUMPRODUCT(--($J$1:$J$10="tom"),--($L$1:$L$10="YES"))

adjust ranges to suit. Can't use whole columns with Sumproduct in pre-XL2007

 

[VoG]

Try

=SUMPRODUCT(--(J1:J100="tom"),--(L1:L100="YES"))

 

[kelscot30]

Guys as always yous are amazing! I should come here before I boggle my brain for half an hour but like to give it a bash myself first lol

Thanks again, have a nice weekend xxxxxxx