Can anyone give me a simple interpretation of this formula
=SUM(IF(ISTEXT(A2:E2))
Can anyone give me a simple interpretation of this formula
=SUM(IF(ISTEXT(A2:E2))
Re: Istext
IsText() returns True or False depending if the value being checked is Text (Not Number/Date/Boolean).
IF() needs 2 parameters, The True Part and the False Part
Sum() does as it says - it sums values.
Your formula may not work as written. What did you want to do?
Re: Istext
Just keeping it simple and covering all eventualities...
Don’t have an account yet? Register yourself now and be a part of our community!