Excel ISTEXT Function Tips

Understanding And Doing Better With SUMIF Function

SUMIF() functions is among the most commonly used functions in excel. Whenever ever we have to sum against a given criteria we revert to this function, be the criteria be only one or more then one (for more then one criteria’s we use SUMIFS(), just another function of this family).

Operation with IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions

Using IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions.