counta formula

E

excelguy

I have the formula =10/counta(E6:E15 ).
This gives me 10/10 if E6 through E15 are filled.

How do I make this formula:
=10/counta( E6:E15 but exclude the cells from this range that equal any of
the numbers in B5:B8)


Example:
=10/counta(E6:E15) would be 10/10 if E6:E15 are filled

but if E12 = B5, excel would give me 10/9 because E12 would be excluded
 
J

JBeaucaire

This is an array formula, confirm it by pressing CTRL-SHIFT-ENTER:

=10/COUNTIF(E6:E15, "<>" & B5:B8)

Does that help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counta formula 4
sum every nth cell in a row 5
Countifs formula 2
Payment calculation 1
Formula 6
Help with formula 1
Tricky Formulas 14
Tricky Formula 2

Top