+ Reply to Thread
Results 1 to 2 of 2

=CountIf to Count Multiple Entries

  1. 07-21-2008, 08:23 AM #1
    scotfitz
    scotfitz is offline
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    =CountIf to Count Multiple Entries

    I want to count the number of text fields in a
    column which are labeled R1, R2, R3.

    I can count them seperately =COUNTIF(A20:A35,"R1")
    however, I want to count R1s, R2s and R3s total.

    I have tried =COUNTIF(A20:A35,"R1:R3") but I do not
    get a correct answer.

    Is there another way to phrase this?

    Thanks
    Reply With QuoteRegister To Reply
  2. 07-21-2008, 08:28 AM #2
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Try

    =SUM(COUNTIF(A20:A35,{"R1","R2","R3"}))
    or
    =SUMPRODUCT(--(A20:A35={"R1","R2","R3"}))
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1