The conditions are:
There are multiple reference cells and all of those should be number, if one becomes a letter or not a number, it would prompt, "ERROR" or "FALSE" or "INVALID", if in case all cells are numbers, it would proceed to SUM it all up.
I've tried IF with ISNUMBER function but it only works with a single cell/value.
Please help.
Thanks.
There are multiple reference cells and all of those should be number, if one becomes a letter or not a number, it would prompt, "ERROR" or "FALSE" or "INVALID", if in case all cells are numbers, it would proceed to SUM it all up.
I've tried IF with ISNUMBER function but it only works with a single cell/value.
Please help.
Thanks.