Hi Dave,

Capital O as in Oh

I've tried this on a new spreadsheet and it works just fine - something on
the existing sheet won't allow any of the acronyms to be seen in a new
formula. I've turned off 'Autosum' and 'Subtotals' to see if these affected
it but no change. I can put these acronyms in another column and alter the
formula and they work.


"Dave Peterson" wrote:

Do you have (oh) T T or (zero) T T in the cell?

And does it match what you have in the formula?



Bonkers wrote:

I'm using this formula =sumproduct(--(G33:G37="OTT"),N33:N37) this should sum
values of N33 throug N37 if the corresponding G33 through G37 has OTT in the
cell. It returns 0. If I change the contents of cells G33:G37 from OTT to
another group of letters such as dl and update the formula it returns the
correct response. What could possibly be wrong with using OTT in the cell
that it won't work in the formula - very strange.

--

Dave Peterson