Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 08, 04:36 PM posted to microsoft.public.excel.newusers
SD SD is offline
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 24
Default Formula not working

..I am just turing to Take a Total (B2) and subtract b4:60 and I get a value
error message. My formula looks like this =Sum B2 - B4:B60 What I I doing
wrong!!!

Thanks -
--
Sandy

  #2   Report Post  
Old May 20th 08, 04:42 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default Formula not working

IF? you are trying to subtract the sum of b4;b60 from b2

=b2-sum(b4:b60)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SD" wrote in message
...
.I am just turing to Take a Total (B2) and subtract b4:60 and I get a
value
error message. My formula looks like this =Sum B2 - B4:B60 What I I doing
wrong!!!

Thanks -
--
Sandy


  #3   Report Post  
Old May 20th 08, 05:19 PM posted to microsoft.public.excel.newusers
SD SD is offline
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 24
Default Formula not working

THANK YOU!!!

--
Sandy


"Don Guillett" wrote:

IF? you are trying to subtract the sum of b4;b60 from b2

=b2-sum(b4:b60)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SD" wrote in message
...
.I am just turing to Take a Total (B2) and subtract b4:60 and I get a
value
error message. My formula looks like this =Sum B2 - B4:B60 What I I doing
wrong!!!

Thanks -
--
Sandy



  #4   Report Post  
Old May 20th 08, 07:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default Formula not working


Glad to help but you needn't shout.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SD" wrote in message
...
THANK YOU!!!

--
Sandy


"Don Guillett" wrote:

IF? you are trying to subtract the sum of b4;b60 from b2

=b2-sum(b4:b60)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SD" wrote in message
...
.I am just turing to Take a Total (B2) and subtract b4:60 and I get a
value
error message. My formula looks like this =Sum B2 - B4:B60 What I I
doing
wrong!!!

Thanks -
--
Sandy






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Not working SD Excel Discussion (Misc queries) 1 May 20th 08 05:27 PM
Formula not working Excluxe Excel Worksheet Functions 17 July 13th 07 07:36 PM
Formula Sometimes Working Sometimes Not merry_fay Excel Discussion (Misc queries) 4 December 6th 06 04:36 PM
IF OR formula not working cjpal Excel Discussion (Misc queries) 4 October 23rd 06 07:51 PM
formula not working Micayla Bergen Excel Discussion (Misc queries) 13 May 23rd 05 01:48 PM


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017