Monday, December 29, 2014

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" 


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.
------------------------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment