Anthony

Posts: n/a

Formula error

Hi,

I'm new (still) so I'm sure this is easy, but I can't suss it.

I have this formula to add the total sum (in Â£) from certain cells. The
problem is if some of the cells have no value in them I get an error #value

my formula is : =IF(ISBLANK(K4),"",SUM(R4+R6+R8+R11+R14+P17))

any help apreciated

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
How can I prevent the "division by zero" error in this formula	Watercolor artist	Excel Worksheet Functions	2	June 27th 05 03:31 PM
Formula syntax error - chinese and gibberish	Joshua Fandango	Excel Discussion (Misc queries)	3	March 29th 05 01:27 PM
Formula error...	Jambruins	Excel Discussion (Misc queries)	2	February 24th 05 09:57 PM
Formula Error	Mike R	Excel Discussion (Misc queries)	6	January 15th 05 05:27 AM
Formula MATCH error	peterfc2	Excel Worksheet Functions	0	November 8th 04 05:53 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us