THAT'S IT!

Many thanks.

"Max" wrote:

Maybe just use SUM, which ignores text:
=IF(AND(B113="Anne",ISNUMBER(V113)),SUM(R113:S113) ,"")

(Added a missing FALSE part of it to the IF, adapt the "" to suit)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"EMW103" wrote:
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?