Excel

From Wikicliki
Jump to: navigation, search
 
=SUMPRODUCT(--(YEAR($B$2:$B$620)=2009))
=COUNTIF(N2:N620,"France")

Excelconditional.png