Difference between revisions of "Excel"
From Wikicliki
Line 3: | Line 3: | ||
=COUNTIF(N2:N620,"France") | =COUNTIF(N2:N620,"France") | ||
</pre> | </pre> | ||
+ | |||
+ | [[File:excelconditional.png]] | ||
* Useful templates http://office.microsoft.com/en-us/templates/word-templates-FX102825522.aspx | * Useful templates http://office.microsoft.com/en-us/templates/word-templates-FX102825522.aspx |
Revision as of 06:30, 22 March 2018
=SUMPRODUCT(--(YEAR($B$2:$B$620)=2009)) =COUNTIF(N2:N620,"France")