Countif for more than one criteria

[Linzalin]

Good evening everyone,
I would like some help with a formula if anyone could assist. I have searched a number of forums and not had any luck!
I have created a staffing list with various columns of information. On a separate tab, I would like to count how many times a name appears in column 'E' and in P column how many times it says 'yes'. I want to check the name and yes to appear for it to count. I have tried =COUNTIF(Staff!E:E,Complete!C3)+COUNTIF(Staff!P3:P500,"Yes")
Plus other variations. I think I'm almost there but need some help!!

Also, I have done a custom sort for two columns that needs refreshing
I have seen the new =SORT but it is not showing on my version. Is there something else that would complete this sort as date is added?

Thanks for any help

 

[Joe4]

Welcome to the board!

Try using the COUNTIFS function, which allows for multiple conditions.

 

[Linzalin]

Thanks I've been pm here before but not got my log on! It's always useful!

Change to...?
=COUNTIFS(Staff!E:E,Complete!C3)+(Staff!P:P,"Yes")

I only want it to count if both criteria are met if possible?

 

[Joe4]

I only want it to count if both criteria are met if possible?

Yes, that is what COUNTIFS does, but you have not structured it correctly.
The format is:
=COUNTIFS(range1, condition1, range2, condition2)

Here is a link with examples: MS Excel: How to use the COUNTIFS Function (WS)

(I could do it for you, but I think you will get more out of it trying it yourself!)

 

[Linzalin]

Thanks I've worked it out! I thought there's got to be away!! I'm gradually learning!! Thank you for replying and helping!

 

[Joe4]

You are welcome.