Originally Posted by janiVI
try
=SUM(IF(RANGE="platinum",1,0)) and Ctrl+Shift+Enter
yeah that work but then it doesnt do the count per year!
here is what i tried:
=Sum(IF(AND(
'Consolidation des rapports'!L5:L347="Platinum";YEAR(
'Consolidation des rapports'!J5:J10000)=2003);1;0))
ctrl+shift+enter
and it gives me 0