DIV/0 error

[Kidmon]

I am using excel 2007
I simply need to divide cells that sometime contain numbers or blanks.

My screen shot shows what I want to see in B4. The other formulas return the dreded DIV/) ERROR

I need to know what B3 divided by B5 return. C3C5,D3D5,E3E5 and so on.
Thanx for your help

Excel Workbook
	A	B	C	D	E
1	Category	APR 4/6 - 4/12	APR 4/13 - 4/19	APR 4/20 - 4/26	APR 4/27 - 5/3
2	Daily Pod COUNT	118	171	141	130
3	Average Daily 2N Count	20	21	20	19
4	Average 2N Stay	6.56	#DIV/0!	###
5	No. of Individual inmates	3	0	0	0
APR 6 - JUN 28, 2011

Excel 2010

Cell Formulas
Range	Formula
B2	=SUMIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">="&"4/6/2011"+0,'2N Stats'!$D:$D,"<="&"4/12/2011"+0)
B3	=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=4/6/2011",'2N Stats'!$D:$D,"<=4/12/2011")
B4	=(B3/B5)
B5	=COUNTIFS('2N Stats'!$B:$B,"Individual Inmate",'2N Stats'!$D:$D,">="&"4/6/2011"+0,'2N Stats'!$D:$D,"<="&"4/12/2011"+0)
C2	=SUMIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">="&"4/13/2011"+0,'2N Stats'!$D:$D,"<="&"4/19/2011"+0)
C3	=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=4/13/2011",'2N Stats'!$D:$D,"<=4/19/2011")
C4	=(C3/C5)
C5	=COUNTIFS('2N Stats'!$B:$B,"Individual Inmate",'2N Stats'!$D:$D,">="&"4/13/2011"+0,'2N Stats'!$D:$D,"<="&"4/19/2011"+0)
D2	=SUMIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">="&"4/20/2011"+0,'2N Stats'!$D:$D,"<="&"4/26/2011"+0)
D3	=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=4/20/2011",'2N Stats'!$D:$D,"<=4/26/2011")
D4	=(D3/D5)
D5	=COUNTIFS('2N Stats'!$B:$B,"Individual Inmate",'2N Stats'!$D:$D,">="&"4/20/2011"+0,'2N Stats'!$D:$D,"<="&"4/26/2011"+0)
E2	=SUMIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">="&"4/27/2011"+0,'2N Stats'!$D:$D,"<="&"5/3/2011"+0)
E3	=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=4/27/2011",'2N Stats'!$D:$D,"<=5/3/2011")
E4	=IFERROR(QUOTIENT(E2,E5),"")
E5	=COUNTIFS('2N Stats'!$B:$B,"Individual Inmate",'2N Stats'!$D:$D,">="&"4/27/2011"+0,'2N Stats'!$D:$D,"<="&"5/3/2011"+0)

 

[T. Valko]

I am using excel 2007
I simply need to divide cells that sometime contain numbers or blanks.

My screen shot shows what I want to see in B4. The other formulas return the dreded DIV/) ERROR

I need to know what B3 divided by B5 return. C3C5,D3D5,E3E5 and so on.
Thanx for your help

Excel Workbook
	A	B	C	D	E
1	Category	APR 4/6 - 4/12	APR 4/13 - 4/19	APR 4/20 - 4/26	APR 4/27 - 5/3
2	Daily Pod COUNT	118	171	141	130
3	Average Daily 2N Count	20	21	20	19
4	Average 2N Stay	6.56	#DIV/0!	###
5	No. of Individual inmates	3	0	0	0
APR 6 - JUN 28, 2011

Excel 2010

Cell Formulas
Range	Formula
B2	=SUMIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">="&"4/6/2011"+0,'2N Stats'!$D:$D,"<="&"4/12/2011"+0)
B3	=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=4/6/2011",'2N Stats'!$D:$D,"<=4/12/2011")
B4	=(B3/B5)
B5	=COUNTIFS('2N Stats'!$B:$B,"Individual Inmate",'2N Stats'!$D:$D,">="&"4/6/2011"+0,'2N Stats'!$D:$D,"<="&"4/12/2011"+0)
C2	=SUMIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">="&"4/13/2011"+0,'2N Stats'!$D:$D,"<="&"4/19/2011"+0)
C3	=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=4/13/2011",'2N Stats'!$D:$D,"<=4/19/2011")
C4	=(C3/C5)
C5	=COUNTIFS('2N Stats'!$B:$B,"Individual Inmate",'2N Stats'!$D:$D,">="&"4/13/2011"+0,'2N Stats'!$D:$D,"<="&"4/19/2011"+0)
D2	=SUMIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">="&"4/20/2011"+0,'2N Stats'!$D:$D,"<="&"4/26/2011"+0)
D3	=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=4/20/2011",'2N Stats'!$D:$D,"<=4/26/2011")
D4	=(D3/D5)
D5	=COUNTIFS('2N Stats'!$B:$B,"Individual Inmate",'2N Stats'!$D:$D,">="&"4/20/2011"+0,'2N Stats'!$D:$D,"<="&"4/26/2011"+0)
E2	=SUMIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">="&"4/27/2011"+0,'2N Stats'!$D:$D,"<="&"5/3/2011"+0)
E3	=AVERAGEIFS('2N Stats'!$G:$G,'2N Stats'!$D:$D,">=4/27/2011",'2N Stats'!$D:$D,"<=5/3/2011")
E4	=IFERROR(QUOTIENT(E2,E5),"")
E5	=COUNTIFS('2N Stats'!$B:$B,"Individual Inmate",'2N Stats'!$D:$D,">="&"4/27/2011"+0,'2N Stats'!$D:$D,"<="&"5/3/2011"+0)

Try this...

=IFERROR(B3/B5,"")

Copy across

 

[Jon von der Heyden]

Please stick with your original thread. Per the forum rules threads of duplicate nature will be locked or deleted.