yogi_Given A Table Containing Dates And States Compute Count By State(s) For Specified Week Numbers

             Google Spreadsheet   Post  #1868

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-29-2014

post by  Alex Paras:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/DbNOmaDtbhA
Getting Weekly Results in Google Spreadsheet

'm trying to get an agents weekly results. I tried countifs but, it doesn't seem to work. The error I get is "Countifs are of different sizes" 

Link: https://docs.google.com/spreadsheets/d/1OqP4krC2xSAQHuYs8MIwsnNzZTyLa7asvYrQO--sSBw/edit?usp=sharing

My Goal:

Agent1 Summary

                   State1          State2            State3

Week 1        count          count               count

Week 2        count          count               count

Week 3

Week 4

Hope someone can help.

------------------------------------------------------------------------------------------------------------------------------------------------