Saturday, May 31, 2014

yogi_Compute Row By Row Number Of Days of Activity By Specified Client During a Speified Month


                                         Google Spreadsheet   Post  #1659
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-31-2014
post by romgl -- question by Polish user: (https://productforums.google.com/forum/#!mydiscussions/docs/O9TCwKC5fPs)

Hi Yogi,

Thanks for your reply. I will rephrase my question:

I am trying to find a formula, that can help me count the number of days a client was active in a chosen month, as shown in the test spreadsheet with the link below :


Thus, for example, in the link above, on the Client activity sheet, if I choose February, I should see the following results :

Client A   2
Client B   2
Client C   0


But if I select April, I should see the following :

Client A   1
Client B   0
Client C   0

Thanks again for your efforts in helping me with this.
------------------------------------------------------------------------------------------------------------------------------------------------