No - if I change the cell to any other word it works fine - leads me to
believe the contents of the cells are somehow linked to another function that
won't allow their inclusion in a formula or somehow renders them
unrecognizable. I'm working with someone else's spreadsheet so I'm not
totally familiar with what has been done.

"Sandy Mann" wrote:

Is Calculation set to Manual?

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Bonkers" wrote in message
...
Thanks Gary but no - no space in OTT. The column contains many different
acronyms (not just OTT) and none of them work until I change the acronym
to
something else, alter the formula to reflect that change. Once again -
very
strange!

"Gary''s Student" wrote:

One possibility is that the cells in column G contain OTT followed by a
space.
--
Gary''s Student


"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.