Thread
:
Any Excel gurus around?
View Single Post
08-30-2016, 09:36 AM
#
18
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.
mhailey
View Public Profile
Send a private message to mhailey
Find More Posts by mhailey