COUNTIF help please

[Patriot2879]

Hi good morning, I have the =COUNTIF code below, where it counts 'Replan' if it Is in Row G, but I want to also count another word in a different row for example Row F and the word is 'Cumbria', so I only want it to count if replan and cumbria match, can you help please?

=COUNTIF(North!G:G,"Replan")

 

[steve the fish]

Sure use COUNTIFS instead and add the other criteria in the same way as you added into your countif.

 

[Nishant94]

=COUNTIFS(North!G:G,"Replan",North!F:F,"Cumbria")

 

[Patriot2879]

great thank you for your help