Solved

#Value Error

Posted on 2014-09-09
3
89 Views
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
0
Comment
Question by:squirrelzan
  • 2
3 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 40312922
No attachment?
0
 

Accepted Solution

by:
squirrelzan earned 0 total points
ID: 40312926
Sorry, here is the attachment.
--orbitonline.com-Private-NSL-HomeDir-fa
0
 

Author Closing Comment

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

Thank you
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now