Results 1 to 2 of 2

Thread: Combing columns + ranges

  1. #1

    Combing columns + ranges



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello I have two columns that I need to match then count based on certain criteria. Example

    Column 1 Column 2
    1 Dog
    1 Dog
    1 Cat
    0 goat
    0 cat
    0 dog
    1 dog
    1 dog
    0 dog

    What I'd like to say is "If the range in column 1 is equal to 1 AND the range in column 2 is equal to Dog, then count the "1's" in column 1. "If the range in column 1 is equal to 1 AND the range in column 2 is equal to Cat, then count the "1's" in column 1. Etc.

    Anyone assist? Thank you very much.

  2. #2
    Not quite sure what you’re looking for, you can try this:
    If this is not what you’re looking for show what you would like the resulting column to look like.


    Column C
    In C1 write Dog
    Insert formula into (C2) =SUMIFS($A2:$A$20,$B2:$B$20,$C$1)

    Column D
    In D1 write Cat
    Insert formula into (D2) =SUMIFS($A$2:$A$20,$B$2:$B$20,$D$1)

    Column E
    In E1 write Goat
    Insert formula into (E2) =SUMIFS($A$2:$A$20,$B$2:$B$20,$E$1)

    Column Results would be:

    C
    DOG
    4

    D
    Cat
    2

    E
    Goat
    0

Posting Permissions

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