Farah Mohammed
asked on
#Value Error
As per attached spreadsheet, When a character is entered in cell in column S (say, S24), it gives a #value error in cell Z34.
If column S is blank, there is no error and the sum value appears.
All help/suggestions is appreciated.
Thank you
If column S is blank, there is no error and the sum value appears.
All help/suggestions is appreciated.
Thank you
No attachment?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I used SUM(Z24,Z25,Z26) instead of SUM(Z24:Z26).
Thank you
Thank you