3 function formula

[NAGreen]

Hello -

This is the formula that Ive got:

=(COUNTIF(E21:E23,"Y")/COUNTA(E21:E23)/IFERROR(E24,""))

It works great on providing me a percentage until I add in the if error, then the % automatically go to 0. What am I doing wrong?

 

[AhoyNC]

Is E24 where you have the formula? If so try:

=IFERROR(COUNTIF(E21:E23,"Y")/COUNTA(E21:E23),"")

 

[NAGreen]

Is E24 where you have the formula? If so try:

=IFERROR(COUNTIF(E21:E23,"Y")/COUNTA(E21:E23),"")

How about this one?

=H26+(AVERAGE(B39:H39))

 

[Joe4]

How about this one?

=H26+(AVERAGE(B39:H39))

What's the question regarding this one?

 

[NAGreen]

It also comes up with the #Div/0. I would like the cell to show the average of the numbers even if not all of the cells are filled in yet. Does that make sense?

 

[AhoyNC]

If you have Excel 2010 or later try:

=H26+AGGREGATE(1,6,B39:H39)

 

[glfiedler]

Put this formula in the cell where you want the average. You will avoid an error and it there are no values in your list the average will show as a null string.
=IF(COUNTA(E21:E23)=0,"",AVERAGE(E21:E23))

 

[AhoyNC]

If all the cells are blank then:

IFERROR(H26+(AVERAGE(B39:H39),"")

If there is an error in one or more of the cells then the formula in post#6

Excel Workbook
	A	B	C	D	E	F	G	H
26					7.2			4
38
39		2	5	#DIV/0!	2		2	5
Sheet