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