|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 17th, 2010, 09:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0! ERROR
I have a worksheet that has a number of rows in each of several different
categories. Before any information is entered, each row shows a 0 sum. When information is entered in the first cell of a given row, a new sum is entered for that row based on the formulas in the rows. In each category, the sums column computes an average. I have that formula working so that it disegards any 0's, but until the first cell in at least one row has something entered, the average cell shows "#DIV/0!". I need to compute a master average of these individual averages, but not all catgories will have information. My master average shows #DIV/0! if any of the individual averages show the error. Any ideas? -- dbconn 
|
|
#2
January 17th, 2010, 10:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! ERROR
=IF(ISERROR(yourformula),"",yourformula)
-- Gary''s Student - gsnu200909
|
|
#3
January 18th, 2010, 08:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0! ERROR
Get rid of the 0 sums until data entered.
=IF(COUNT(A1:C1)2,"",SUM(A1:C1)) Your Average formula will ignore "" Gord Dibben MS Excel MVP On Sun, 17 Jan 2010 13:41:01 -0800, dbconn wrote: I have a worksheet that has a number of rows in each of several different categories. Before any information is entered, each row shows a 0 sum. When information is entered in the first cell of a given row, a new sum is entered for that row based on the formulas in the rows. In each category, the sums column computes an average. I have that formula working so that it disegards any 0's, but until the first cell in at least one row has something entered, the average cell shows "#DIV/0!". I need to compute a master average of these individual averages, but not all catgories will have information. My master average shows #DIV/0! if any of the individual averages show the error. Any ideas?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
