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)"
Printable View
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)"
Try this.
Code:="The number of attendees are: "& COUNTIF(K:K,"Y")+ COUNTIF(K:K,"Yes")
or
Code:="The number of attendees are "&SUMPRODUCT(--(A1:A19={"Yes","Y"}))
thanks guys
:thumb