Wednesday, May 17, 2017

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:

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