formulas and drop down lists

  • Thread starter Thread starter drwrbrts
  • Start date Start date
D

drwrbrts

I have a table of data converted into a dropdown list that contains a
few columns with just "yes" or "no" entries. I created a formula below
the actual blue border of the list to calculate the percentage of yes'
in the list:
=COUNTIF(E2:E40,"Yes")/(COUNTIF(E2:E40,"Yes")+COUNTIF(E2:E40,"no"))

However, this only calculates the data for the entire list, even when I
have filtered it. How do I modify it to apply only to the filtered
entries in the list? Thanks if you can help, guys.
 
Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(E2:E40,ROW(E2:E40)-ROW(E2),0,1)),--(E2:E40=
"Yes"))/SUBTOTAL(3,E2:E40)

Hope this helps!
 

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

Ignoring blanks from Column(s) 3
IF, AND for different Columns 2
A formula, probably quite simple..... 1
Need Help FAST with COUNTIF Formula 0
How calculate difference between [t]:mm-format and general format 3
HELP! I need to make an IF Statement comparing date/time fields.. 2
Excel Need Countifs Formula Help 0
array formula 1

Back
Top