Countifs specific word in column a and if specific word in column b

[Zabelle]

Hi,

Need your help please...

I am looking for a formula, I need to count only if NOT DEFINED in one Column and IMPLEMENTED in the next Column, the information is side by side within a range.

=COUNTIFS('2019-2020 LIST '!$I$2:$I$76;"NOT DEFINED";AND IF; '2019-2020 LIST '!$G$2:$G$76;"IMPLEMENTED")

Could I also add a third word in a third column?

Thank you!

Zabella

 

[Scott Huish]

Yes. But your syntax is wrong, there is no AND IF statement in that. I'm in the US so I'm using commas instead of semicolons.

=COUNTIFS('2019-2020 LIST '!$I$2:$I$76,"NOT DEFINED", '2019-2020 LIST '!$G$2:$G$76,"IMPLEMENTED", '2019-2020 LIST '!$J$2:$J$76,"ANOTHER WORD")

 

[Zabelle]

Yes. But your syntax is wrong, there is no AND IF statement in that. I'm in the US so I'm using commas instead of semicolons.

=COUNTIFS('2019-2020 LIST '!$I$2:$I$76,"NOT DEFINED", '2019-2020 LIST '!$G$2:$G$76,"IMPLEMENTED", '2019-2020 LIST '!$J$2:$J$76,"ANOTHER WORD")

Thank you! It's working!! Fantastic!! Yes my Excel is semicolons instead of commas.