+ Reply to Thread
Results 1 to 5 of 5

Grab the number of x in column a if found in column b under a specific name

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    Cola SC
    MS-Off Ver
    Excel 2010
    Posts
    73

    Question Grab the number of x in column a if found in column b under a specific name

    Hello -
    I am currently trying to locate a formula that will provide the total number of product located in a particluar state.
    Column A lists various products (i am only interested in one, e.g. Laptops)
    Column B lists a number of states

    I want the number of Laptops located in PA. How would i go about doing that?

    Thank you in advance for any help you may be able to provide.

    HNOEL

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Grab the number of x in column a if found in column b under a specific name

    use SUMIFS

    =SUMIFS(

    A = product
    B = State
    do you have quantity column C ?
    or do you have a row per item

    if a row per item
    countifs()

    this example change A3:A6 & B3:B6 to your range

    =COUNTIFS(A3:A6,"laptop",B3:B6,"PA")

  3. #3
    Registered User
    Join Date
    04-24-2013
    Location
    Cola SC
    MS-Off Ver
    Excel 2010
    Posts
    73

    Red face Re: Grab the number of x in column a if found in column b under a specific name

    Awesome! Thank you so so much!
    I APPRECIATE IT!
    I am learning so much on here...

    thanks again and have a wonderful weekend!
    HnOEL

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Grab the number of x in column a if found in column b under a specific name

    your welcome :up: thanks for letting us know

    to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    I am learning so much on here...
    me too answering questions and looking at replies too

  5. #5
    Registered User
    Join Date
    04-24-2013
    Location
    Cola SC
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Grab the number of x in column a if found in column b under a specific name

    It is amazing the stuff i am learning on here.
    Once you have the basics... and someone helps you with certain formulas - it becomes automatic. I am loving this
    I know I know.. too much excitement over excel for a Friday. lol

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1