+ Reply to Thread
Results 1 to 4 of 4

Formula Needed to count a range of cells based on criteria in 2 other cells

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Formula Needed to count a range of cells based on criteria in 2 other cells

    For this example I will use A1:A10, B1:B10, C1:C4 and D1:D4


    A1:A10 = An Employee ID number; either 1, 2, 3, or 4
    B1:B10 = 2 letters will be entered in these cells which represent a type of sale. "A" and "U"
    C1:C4 = formula (where the totals will appear based on criteria entered in A1:A10 and B1:B10) Only count if "A" is entered
    D1:D4 = formula (where the totals will appear based on criteria entered in A1:A10 and B1:B10) Only count if "U" is entered

    Can someone help me with this? thanks

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Formula Needed to count a range of cells based on criteria in 2 other cells

    Assuming thath you need to count 1,2,3,4 and "U" and then 1,2,3,4 and "A"
    =COUNTIFS(A2:A10,1,B2:B10,"U")
    Change 1 to 2 then to 3 and then change U to A
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Re: Formula Needed to count a range of cells based on criteria in 2 other cells

    thank you, works great

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Formula Needed to count a range of cells based on criteria in 2 other cells

    You are welcome.
    Please add reputaion to my name.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula needed to only count total cells entered and not count adjacent text entered cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2013, 06:22 PM
  2. Count a Range of cells if another range of cells meets criteria
    By mjg060468 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-21-2013, 02:57 PM
  3. [SOLVED] Macro needed to clear cells in range based on value of cells in another range
    By msmith7113 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2013, 12:32 AM
  4. Replies: 6
    Last Post: 11-11-2012, 12:40 AM
  5. Replies: 2
    Last Post: 06-24-2010, 04:53 PM

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