countif
Try:
=COUNTIF(E1:E100,"Fair")
Mike
" wrote:
i was asking help for tabulating the results of a feedback form.
if i have 100 feedback forms, how do i count the number of 'fair'
responses in question1?
example, in coulmn E i have responses including 'fair', 'good' and
'excellent'.
someone adviced me to use the countif formula..
but, how come it only works for some cells?
need it urgently.. if there is another method, pls reply to this
post..
thx alot.
|