Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brento
 
Posts: n/a
Default #DIV/0! query


Hi All,

Could anyone please help me to fix this problem. I am trying to sum a
row of data but because it has a DIV/0 cell it will not add the data.

The DIV/0 is a cell with a simle formula awaiting data to be added at a
later date.

Is there any way to add the data and exclude to div/0 cells but not
manaully write a formula suming individual cells?

Any sudgestion would be greatly and urgently appreciated.

Thanks
Brent


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=507003

 
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
Anyone Else Use Database Query to Query Another Sheet in the Same Ron Coderre Excel Discussion (Misc queries) 0 November 28th 05 06:16 PM
AHHH! Again JAA149 Excel Discussion (Misc queries) 0 October 31st 05 11:36 AM
Web Query Help... Jambruins Excel Discussion (Misc queries) 1 July 29th 05 06:56 PM
"Query cannot be edited by the Query Wizard" PancakeBatter Excel Discussion (Misc queries) 0 April 25th 05 05:59 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 08:31 AM.

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

About Us

"It's about Microsoft Excel"