Better switch to a Sum/If formula when a vector and a matrix involved:

=SUM(IF(D2:D100=D112,E2:P100))

which needs to be confirmed with control+shift+enter.

In fact, it's not unreasonable to create a total per record in an
aditional column and invoke an ordinary Sumif formula:

Q2, copied down:

=SUM(E2:P2)

Then:

=SUMIF(D2:D110,D112,Q2:Q110)

Barb Reinhardt wrote:
I want to sum the values in cells E2:P110 based on the values column D. The
values in D are formulas resulting in something that appears to match D112 in
some cases. I'm using the following equation:

=SUMIF(D2:D110,D112,E2:P110)

My problem is that D2 :D10 have a formula in it and it's not matching. If
I enter the result of the formula, all is good. How should I deal with this?

Thanks in advance,
Barb Reinhardt