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                            www.energyefficientbuild.com

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
Jane
Alan
Alana
...
...
...
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