Countifs

    =SUM(COUNTIFS('Raw Data'!E:E,"Fix",'Raw Data'!F:F,mySelection))


    returns 131 for me.

    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

    Instead of using the standard Enter key ....


    Use simultaneously the 3 Keys : Control Shift Enter


    You will see curly brackets surrounding your formula .... and hopefully the correct result ...;)

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

    You can use:


    =SUMPRODUCT(COUNTIFS('Raw Data'!E:E,"Fix",'Raw Data'!F:F,mySelection))


    and just enter it normally.

    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

    Quote from pjums

    WORKS!

    Thanks a lot :)

    Thanks for your Thanks :thumbup:

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

    Hello,


    Just marked your Thread As Resolved ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" 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!

Register Yourself Login