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   May-31-2014
post by romgl -- question by Polish user: (!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.