PDA

View Full Version : [SOLVED:] Counter


Shaolin
05-01-2005, 03:22 PM
Is there a way to count the number of "Yes" and "Y" in column K and display that on cell J1 that reads "The number of attendees are: (the number here)"
Jacob Hilderbrand
05-01-2005, 03:27 PM
Try this.


="The number of attendees are: "& COUNTIF(K:K,"Y")+ COUNTIF(K:K,"Yes")
Bob Phillips
05-02-2005, 04:27 AM
or


="The number of attendees are "&SUMPRODUCT(--(A1:A19={"Yes","Y"}))
Shaolin
05-02-2005, 06:09 AM
thanks guys

:thumb