OK, trying to reply again: yes, both the R and S cells are the result of
formulas, and the S cell formula has a text as one of its values. Is that
the problem?

"T. Valko" wrote:

The problem is he

R113+S113

One of those cells, or both, probably contain a TEXT entry.

Are there formulas in those cells?

--
Biff
Microsoft Excel MVP


"EMW103" wrote in message
...
=IF(AND(B113="Anne",ISNUMBER(V113)), R113+S113)

What am I doing wrong? All I get is "VALUE", with no help.