Counta() Formula

[excelhelp12]

[FONT=Times New Roman, Times, serif]Hello,[/FONT]
[FONT=Times New Roman, Times, serif][/FONT]
[FONT=Times New Roman, Times, serif]I was wondering if you could could help me out with this question:




</PRE>
[FONT=Times New Roman, Times, serif]I have the formula =0.10/counta(E6:E15 ).[/FONT]
[FONT=Times New Roman, Times, serif]This gives me 0.10/10 if E6 through E15 are filled.[/FONT]
[FONT=Times New Roman, Times, serif][/FONT]
[FONT=Times New Roman, Times, serif]How do I make this formula:[/FONT]
[FONT=Times New Roman, Times, serif]=0.10/counta( E6:E15 but exclude the cells from this range that equal any of the numbers in B5:B8)[/FONT]
[FONT=Times New Roman, Times, serif][/FONT]
[FONT=Times New Roman, Times, serif]Example:[/FONT]
[FONT=Times New Roman, Times, serif]=0.10/counta(E6:E15) would be 0.10/10 if E6:E15 are filled[/FONT]
[FONT=Times New Roman, Times, serif]but if E12 = B5, excel would give me 0.10/9 because E12 would be excluded[/FONT]


[FONT=Times New Roman, Times, serif]Thanks[/FONT]




</PRE>[/FONT]

 

[pgc01]

Hi
Welcome to the board

Try:

=0.10/SUMPRODUCT(--(E6:E15<>""),--ISNA(MATCH(E6:E15,B5:B8,0)))