yogi_Array Formula of SUMIFS with partial cell text match not expanding

Google Spreadsheet   Post  #2163

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-17-2017

question by Clayton Clixo:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/HW0hH2u49Uk;context-place=forum/docs

Array Formula of SUMIFS with partial cell text match not expanding

I'm having trouble with an arrayformula that won't expand. It's in cells B4 and C4 on the summary tab. I know the base sumifs formula works and if I copy down the array formula to lower cells it works, but it won't expand by itself. Any help is much appreciated!

Maybe it's not running because:

 - using sumif that is looking up a partial text string within a cell?

 - referencing a cell value that's populated by another array formula (column A on summary tab)

Sample spreadsheet