Forum Discussion
Solved
Are realized spills a different type of thing than the same result calculated in LET?
When I use the # construct to utilize realized spilled output as input into SUMIF it works, but if I use the same data calculated in LET it does not. I assume this means the realized spill is one typ...
In this part
SUMIFS(values,names,C17#)
you try to use array (values) as sum range. SUMIFS works only with ranges here, not arrays.
Thanks Sergei. This was the first moment that I understood "C17#" is not an array. Also thank you for the formula, I would never have figured that out.
boukasa , glad to help