Posted to microsoft.public.excel.worksheet.functions

Art

external usenet poster

Posts: 587

#value! error in sum function

I need to sum a range of cells. Some of the cells may contain text. If so,
the function returns #value!. In Lotus 1-2-3, text is treated as 0 for
function purposes. Is there some way to force Excel to do the same, or
another way to get around this problem?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Function error	nc	Excel Worksheet Functions	1	January 30th 09 02:05 PM
if function error	AHizon via OfficeKB.com	Excel Worksheet Functions	3	September 12th 08 05:54 AM
Possible error in MOD function	Peter K[_2_]	Excel Worksheet Functions	2	February 23rd 08 01:53 AM
3D Function Error	srpettew	Excel Discussion (Misc queries)	2	April 18th 06 09:48 PM
IF function with #N/A error	Roccobarocco	Excel Worksheet Functions	4	December 5th 04 08:59 PM

All times are GMT +1. The time now is 06:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us