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.