yogi_Multiply Numeric Values In Test Range By Value In Cell A3 While Leaving Text Entries In TestRange As Is

             Google Spreadsheet   Post  #1908

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-05-2015

question by Perfect Sheets:

https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/tm-DVsEtEv4
How to ignore text when multiplyinga range in an arrayformula.

https://docs.google.com/spreadsheets/d/1vpP8PasIo0K_FaX2m8nKl-RWJWIuayqWAbG82uy3cp0/edit?usp=sharing

I am trying to pull in a a named range where the numbers may not always be in the same cells.  I want to multiply all the content without it creating errors where there is text.

Thank you for any help!

------------------------------------------------------------------------------------------------