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