Saturday, November 29, 2014

yogi_Count The Number Of Invlalid Entries In A2 To A With Valid Entries Specified In C5 To C

              Google Spreadsheet   Post  #1850
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-30-2014
post by  Don Lawson:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/dh7uB_anZsU
Count cells with invalid data
Is it possible to use a formula or script to count the number of cells in a given range that have data that violates the validation rules?
---------------------------------------------------------------------------------------------------------------------------------------