title: How to optimize COUNTIFS with very large data
body: <p>I would like to create a report that look like this picture below. <br>
  My data has around 500,000 cells (it will continue to grow larger) <br> <br>
  Right now, I'm using countifs function from excel but it takes a very long time to calculate. (cannot turnoff automatic calculate) <br> <br>
  The main value is collected as date and the range of date is about 3 years, so I have to put a lot of formula to cover all range of value.</p>
  
  <p><img src="https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-xpf1/v/t1.0-9/988459_701467203302504_2667600209275229377_n.jpg?oh=28850ac03b23d2bfbc1afede19d96ec2&amp;oe=556E57E9&amp;__gda__=1428451333_4ab6f68baae6b87bb46d8e75041c07ce" alt="result"><a href="https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-xpf1/v/t1.0-9/988459_701467203302504_2667600209275229377_n.jpg?oh=28850ac03b23d2bfbc1afede19d96ec2&amp;oe=556E57E9&amp;__gda__=1428451333_4ab6f68baae6b87bb46d8e75041c07ce" rel="nofollow">result</a>
  <br>
  <br/>
  The picture below is the datasource the top one cannot be changed. , while the bottom is the one I created by myself (can change). I use weeknum to change date to week number.</p>
  
  <p><img src="https://fbcdn-sphotos-b-a.akamaihd.net/hphotos-ak-xfp1/v/t1.0-9/1012966_701467206635837_6234293700065069575_n.jpg?oh=bc5c9ea5765c1d36ea7f4251ac3b7db0&amp;oe=556C36A9&amp;__gda__=1432896050_ee7f07409a22e380d1dfcd2b769785cc" alt="data"><a href="https://fbcdn-sphotos-b-a.akamaihd.net/hphotos-ak-xfp1/v/t1.0-9/1012966_701467206635837_6234293700065069575_n.jpg?oh=bc5c9ea5765c1d36ea7f4251ac3b7db0&amp;oe=556C36A9&amp;__gda__=1432896050_ee7f07409a22e380d1dfcd2b769785cc" rel="nofollow">data</a>
  <br> <br>
  Are there any better formula or any ways to make this file faster? Every kinds of suggestions are welcome! <br>
  I was thinking about using Pivot Table, but I don't know how to make pivot table from this kind of datasource. <br>
  PS. VBA is the last option.</p>
  
  <p>You can download example file here: <a href="https://www.mediafire.com/?t21s8ngn9mlme2d" rel="nofollow">https://www.mediafire.com/?t21s8ngn9mlme2d</a></p>