+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : combining two countif statements

  1. #1
    Registered User
    Join Date
    02-23-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    combining two countif statements

    Hello,
    I'm not sure if I'm using the correct terminology, so please forgive me.

    I have a spreadsheet with two tabs - Tab 1 has several columns: 1=data, 2=name, 3=date. Tab 2 is for tracking purposes - I have column 1 as the person's name, column 2 is counting the certain persons name from tab 1/column 2 (=COUNTIF(Master!F2:F2000,"*certain name*")).
    Where I'm having issues is: I need a count of how many dates have been entered for a certain person in tab 2/column 3, from tab 1 column 3. I can get the formula to count the dates (=COUNTIF(Sheet1!R3:R2001,"="&DATE(2012,2,1))).
    How do I combine the two formulas into one to get the end result below?

    The end result should look like:
    Certain name - claimed x amount - entered x dates in field

    Thank you in advance for your help!
    Last edited by stephsmom; 02-23-2012 at 03:11 PM. Reason: SOLVED

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: combining two countif statements

    i think what you are trying to do can be easily accomplished with a countifs statement, i attached what i think you are looking for, but if you have something more specific it could help.Counting Dates.xlsx

  3. #3
    Registered User
    Join Date
    02-23-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: combining two countif statements

    That's the outcome that I want. But how do I adjust the formula to have the "tracking" data on a different tab?
    Tab 1 has all the data (sheet1)
    Tab 2 would be the results or the tracking data (sheet2)
    Last edited by stephsmom; 02-23-2012 at 01:15 PM.

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: combining two countif statements

    just need to reference the sheet in the formula, for example Cell A1 on the same sheet is referenced as "A1" where as Cell A1 on a sheet 2 would be referenced from sheet 1 as "Sheet1!A1"

    you just need to add the sheet name and an !

    hope this helps.

  5. #5
    Registered User
    Join Date
    02-23-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: combining two countif statements

    Thank you for your help DGagnon, but I'm not getting it work.
    I've attached a sample spreadsheet of what I'm trying to do.
    test supplier.xls

  6. #6
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: combining two countif statements

    try =COUNTIFS(Sheet1!F:F,Sheet2!A2,Sheet1!R:R,">0")

  7. #7
    Registered User
    Join Date
    02-23-2012
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: combining two countif statements

    YOU ARE AWESOME DGAGNON!!!

    THANK YOU SO VERY MUCH FOR YOUR HELP!!!

    Have a GREAT day!!
    N~

  8. #8
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: combining two countif statements

    no problem, glad to help.

+ 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