Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2007

Tip: Looking for answers? Try searching our database.

#VALUE!  When Attempting To SUM A Funtion that Does Not Print "FALSE"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fred - 28 Feb 2007 23:12 GMT
Here's what I'm trying to do.

I have a few rows of cells executing a function that inserts a dollar
amount when "Yes" is entered in the adjacent cell.
Here's what the cell looks like

COLUMN I     COLUMN J
"YES"        =IF(I9="YES",15.99,"")
"YES"        =IF(I10="YES",15.99,"")
"YES"        =IF(I11="YES",15.99,"")

As you can see I did my best to avoid Excel from printing "FALSE" when
the cell is empty
The problem is that I'm trying to sum the dollar amounts in COLUMN J
using this function
=J1+J2+J3

What I get in the cell that's adding the three amounts in COLUMN J
is……. #VALUE!  

Can any one help me understand why the dollar amounts will not SUM?

Scott from PA
Dave Peterson - 28 Feb 2007 23:24 GMT
Because "" isn't a number.

You could use:
=sum(J11:j13)

=sum() ignores text.

> Here's what I'm trying to do.
>
[quoted text clipped - 19 lines]
>
> Scott from PA

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.