Friday, February 3, 2012

yogi_Count Number Of Occurences Of Dates As Labels In Style 01/01/2012 Across A Row

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

user sticknrudder said:
For example:
A1 A2 A3 ..... A7
Person    Location A.            Location B        Totals
John   1/1/12,1/2/12,1/5/12    1/7/12,1/12/12         5
All I want is a sum of the number of occurences of "*/*/*" in each cell, summed in that last row. Sorry, this is really basic, but I cannot figure this out and it's killing me.
following is a solution to the problem