Formula Countifs

Marilen.Navarro103391

Hi. I need to write a formula in my Sheet Summary report.

How do I add other countries on my counting.... all countries below belong in one category "South America"

=COUNTIFS({JoseTracker Range 7}, "Argentina".........

Argentina

Brazil

Chile

Colombia

Mexico

Peru

Paul Newcome

Try something like this...

=COUNTIFS({JoseTracker Range 7}, OR(@cell = "Argentina", @cell = "Brazil", @cell = "Chile", @cell = "Columbia", @cell = "Mexico", @cell = "Peru"))

Paul Newcome

Try something like this...

=COUNTIFS({JoseTracker Range 7}, OR(@cell = "Argentina", @cell = "Brazil", @cell = "Chile", @cell = "Columbia", @cell = "Mexico", @cell = "Peru"))