Consulting

Results 1 to 4 of 4

Thread: Counter

  1. #1

    Counter

    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)"

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Try this.

    ="The number of attendees are: "& COUNTIF(K:K,"Y")+ COUNTIF(K:K,"Yes")

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    or

    ="The number of attendees are "&SUMPRODUCT(--(A1:A19={"Yes","Y"}))

  4. #4
    thanks guys


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •