Tuesday, January 28, 2014

yogi_get count of each of the items listed in cells B30:B34 in each column of range C4:I26 Marked with red chain dotted line

                                         Google Spreadsheet   Post  #1503
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-28-2014
post by Matthew Eisenberg (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/-s9-Qd2xAoI)
Assign a numerical value to text
this problem is not about assigning numerical value to text ... it is for getting count of text items
and then summing the instances of text items encountered