Posted to microsoft.public.excel.misc

Misty

external usenet poster

Posts: 10

COPYING SUM/IF FORMULA

I am using excel 2007. Creating a inventory spreadsheet to show initial
quantity and then a continous running total when used. I created a formula to
hide 0 values.
Example =if(sum(c7-e3)=0,"",(sum(c7-e3))).
When I try to copy-my options are copy cell, with formatting or without. It
only copies down the existing answer from the previous cell or I get an error
#value!.
Help!
Thanks

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
Copying a formula	Lisa W.	Excel Discussion (Misc queries)	2	December 4th 07 10:40 PM
Copying formula	MKH Eyrbakk	Excel Worksheet Functions	4	September 27th 07 01:27 PM
copying the Hyperlink function result without copying the actual formula	mcheng	Excel Worksheet Functions	2	June 9th 07 02:43 AM
copying formula	derksj	Excel Discussion (Misc queries)	2	December 5th 06 04:01 PM
copying a formula	Robb27	Excel Discussion (Misc queries)	1	June 17th 06 03:11 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us