Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page help with a formula
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2014, 07:44 AM
srockwell25 srockwell25 is offline help with a formula Windows 7 32bit help with a formula Office 2010 32bit
Novice
help with a formula 		 
Join Date: Aug 2014
Location: Ohio
Posts: 2
srockwell25 is on a distinguished road
Default help with a formula

I am trying to subtract a total of a column from the number in another column. I am entering =sum(B1-(c2:c20)) I get an error code of #value. What am I doing wrong?
Reply With Quote
  #2  
Old 08-21-2014, 08:11 AM
bobsone1 bobsone1 is offline help with a formula Windows Vista help with a formula Office 2007
Novice
  
Join Date: Jul 2014
Posts: 23
bobsone1 is on a distinguished road
Default
Hi
I tried this and it looks like it works

=B1-SUM(C2:C20)

Regards
Reply With Quote
  #3  
Old 08-21-2014, 08:56 AM
srockwell25 srockwell25 is offline help with a formula Windows 7 32bit help with a formula Office 2010 32bit
Novice
help with a formula 		 
Join Date: Aug 2014
Location: Ohio
Posts: 2
srockwell25 is on a distinguished road
Default
thank you! I knew it was simple!
Reply With Quote
  #4  
Old 08-21-2014, 09:05 AM
bobsone1 bobsone1 is offline help with a formula Windows Vista help with a formula Office 2007
Novice
  
Join Date: Jul 2014
Posts: 23
bobsone1 is on a distinguished road
Default
Glad it worked:-)
Reply With Quote
  #5  
Old 08-22-2014, 02:47 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline help with a formula Windows 7 64bit help with a formula Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
Quote:
Originally Posted by srockwell25 View Post
thank you! I knew it was simple!
I wonder how you knew that, not knowing the answer....
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
formulas

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with a formula Formula Excel Excel 1 08-14-2014 05:11 PM
help with a formula IF + AND formula help david_89_ Excel 4 06-11-2014 11:07 AM
Formula Help OTPM Excel 5 02-21-2013 08:03 AM
help with a formula PMT Formula OneOleGuy Excel 4 03-05-2011 09:54 AM
help with a formula If formula sixhobbits Excel 1 10-02-2009 08:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:29 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft