Sheet1Country     Activity1   Activity2Spain       2           2Spain       0           0Italy       1           0France      1           0Germany     0           0Italy       4           2Germany     1           0Belgium     0           0France      0           1Sheet 2Country     Count # >1SpainFranceItalyBelgiumGermanyI'm trying to count in Sheet2 the number of occurrences in Sheet1!ColA if they have >1 in activity 1 OR 2.I can't do:COUNTIFS('Sheet1'A2:A,'Spain','Sheet1'!B2:B,>1)+COUNTIFS('Sheet1'A2:A,'Spain','Sheet1'!C2:C,>1)Because that would count twice if the number is more than 1 for both Activity1 and Activity2.
COUNTIF multiple columns not counting values matching both criterias
google spreadsheets