Any Excel gurus around?

stearns · 08-30-2016, 07:24 AM

F4! F4!

markem · 08-30-2016, 09:34 AM

I decided to put some ideas in one post, so this is a duplicate at first.

Here is the formula, based on your example. This example uses a column value for the limit. Note that you can copy this formula to all the subsequent rows of the column and it will automatically use the right cells. This is an Excel thing, not something I did.

I also noticed the "target" column and decided that selecting from a drop down list that you can maintain in a column, or even on another page, would be nice. Use the "data validation" selection on the "data" tab to get to this.

mhailey · 08-30-2016, 09:36 AM

here is the formula for the average of Yes responses:

=COUNTIF(E2:E5,"Yes")/COUNTA(E2:E5)

08-30-2016, 07:24 AM	#1
stearns Dogbert Consultant Join Date: Oct 2008 First Name: Ben Location: Park Hill Posts: 5,421 Trading: (50)	Re: Any Excel gurus around? F4! F4! __________________ "Ignoring all the racket of conventional reality" - Keller Williams

08-30-2016, 09:36 AM	#3
mhailey Splitter of Hairs Join Date: Mar 2009 First Name: Matt Location: out west Posts: 492 Trading: (21)	Re: Any Excel gurus around? here is the formula for the average of Yes responses: =COUNTIF(E2:E5,"Yes")/COUNTA(E2:E5) __________________ Never try and teach a pig to sing. It frustrates you and irritates the pig.