Difference between revisions of "Excel"
From Wikicliki
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<pre> | <pre> | ||
| − | |||
=SUMPRODUCT(--(YEAR($B$2:$B$620)=2009)) | =SUMPRODUCT(--(YEAR($B$2:$B$620)=2009)) | ||
| − | |||
=COUNTIF(N2:N620,"France") | =COUNTIF(N2:N620,"France") | ||
| + | </pre> | ||
| + | [[File:excelconditional.png|800px]] | ||
| − | + | * Useful templates http://office.microsoft.com/en-us/templates/word-templates-FX102825522.aspx | |
Latest revision as of 06:31, 22 March 2018
=SUMPRODUCT(--(YEAR($B$2:$B$620)=2009)) =COUNTIF(N2:N620,"France")
