#Value Error

Posted on 2014-09-09
Medium Priority
Last Modified: 2014-09-15
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
Question by:Farah Mohammed
  • 2
LVL 37

Expert Comment

by:Neil Russell
ID: 40312922
No attachment?

Accepted Solution

Farah Mohammed earned 0 total points
ID: 40312926
Sorry, here is the attachment.

Author Closing Comment

by:Farah Mohammed
ID: 40322698
I used SUM(Z24,Z25,Z26) instead of SUM(Z24:Z26).

Thank you

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question