Countifs

  • I am sure I am not oing it right but cant get my head around the right way!


    =(COUNTIFS('Raw Data'!E:E,"Fix",'Raw Data'!F:F.'Slicer'!A:A))


    I want the logic to return the count of rows from Raw Data table when column E contains Fix and column F of Raw Data matches any entry present in Column A of the slicer table


    Silcer table looks like this


    Row Labels
    Complex CR
    Incidents
    PRTG Alerts
    Requests
    RFI
    Simple CR
  • Thanks Carim, I think I know how to use countif and that's why believe my logic is not correct but cant figure out how to fix it....


    Perhaps I should rephrase my question and say :


    I need a logic to return the total count of rows from Raw Data table which match 2 criteria:

    1- column E contains Fix

    2- column F of Raw Data matches any entry present in Column A of the slicer table



    I don't care if its countif or anything else, so long as I can have a right output

  • Understand your point ...


    What about the second part of my previous message ...;)


    Quote

    If you would like to tailor-made solution to your specific situation ...


    Please attach a sample file ...:)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)


  • By the way ... aren't you the one ... who has picked as THE thread Title: COUNTIFS ..... ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Your formula will return an array of results, so you need to sum them:


    =SUM(COUNTIFS('Raw Data'!E:E,"Fix",'Raw Data'!F:F.'Slicer'!A:A))

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • If what you want to achieve is even more complex than what you have exposed ...


    .... It is only one Extra reason to attach a sample file ....


    1. Make a copy of your file


    2. In the Copy, remove everything which does not contribute to understand your question


    3. Make sure to explicitly show your expected result .... even if you type it in manually ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Thanks for having designed a sample file ...;)


    Will get back to you asap ...:)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello Pooja,


    Regarding the dates ... i.e. the Year and the Month ... where exactly are they supposed to appear in your worksheet Raw Data ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • they appear in a column that I have deleted !


    Guess what .... it might even be ... the reason ... behind my question ... !!!!8o

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!