Saturday, February 15, 2014

yogi_Compute Number Of Customers By Manager For Each Month of The Specified Year

                                         Google Spreadsheet   Post  #1532
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-15-2014
post by Lionel COSTE (

The aim of the exercice is to count customers who are involved between startDate and endDate, pivot by Manager. The difficulty belongs in the fact that the pivot table may have each month/year a count for the Managers. Each contract "on Air" must be counted for each month of it's period..

based on my understanding of the intent in the question, I present here a solution to the problem