Posted to microsoft.public.excel.misc

Mike H

external usenet poster

Posts: 11,501

Formula Not working

Try

=B2-SUM(B3:B100)

Mike

"SD" wrote:

Hello - I need help! I am trying to add my Total units (B2) and subtract
orders B3:B100. My formula is =Sum B2-B3:100. When I try to do this I
receive a #value! error message.

Please help!
--
Sandy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 only working sometimes	KeK23	Excel Discussion (Misc queries)	2	October 7th 07 11:38 PM
Formula not working	joesf16	Excel Worksheet Functions	2	May 21st 07 04:17 AM
formula is not working	olivia824	Excel Worksheet Functions	2	January 3rd 06 08:03 PM
Why isn't this formula working?	Jambruins	Excel Discussion (Misc queries)	2	July 1st 05 05:25 PM
Formula not working	Carl Hilton	Excel Worksheet Functions	13	January 9th 05 06:55 PM

All times are GMT +1. The time now is 05:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us