Thread: Any Excel gurus around?
View Single Post
Old 08-30-2016, 09:36 AM   #18
mhailey
Splitter of Hairs
 
mhailey's Avatar
1
 
Join Date: Mar 2009
First Name: Matt
Location: out west
Posts: 492
Trading: (21)
mhailey has a spectacular aura aboutmhailey has a spectacular aura aboutmhailey has a spectacular aura about
Default 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.
mhailey is offline   Reply With Quote