What is wrong with this formula??

    Hi Folks.


    I know this is going to be a silly error on my my part, but can anyone tell me why excel is not seeing this as a formula??


    =IFERROR(SUMIFS('Errors-YTD'!$H:$H,>0,'Errors-YTD'!$L:$L,"<="&D$14,'Errors-YTD'!$C:$C="Customer",'Errors-YTD'!$E:$E,$B33),0)


    H:H is a column of numbers and I need it to sum up all the numbers that are above 0


    L:L is a column of dates and the formula looks for any dates less that or equal to the date in D14


    E:E is a list of codes and the formula looks for the code that is in B33


    Somehow I'm missing a quotation or a comma I think..


    Any help, much appreciated as usual please... :)


    Kind regards


    DezB

    Hi,


    At first glance, you should review the basic building structure SUMIFS


    SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)


    In addition whole columns is often counter-productive use defined ranges... ;)

    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 :)

    Thanks 1

    =IFERROR(SUMIFS('Errors-YTD'!$H:$H,'Errors-YTD'!$H:$H,">0",'Errors-YTD'!$L:$L,"<="&D$14,'Errors-YTD'!$C:$C,"Customer",'Errors-YTD'!$E:$E,$B33),0)

    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

    Thanks 1 Like 1

    rory

    Well Done !!! :thumbup:


    Congrats on your exceptional talent of "mind-reader" :)

    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 :)

    Like 1

    It's a gift. ;)

    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

    Like 1

    So am I, especially as I should have seen it right before my eyes, a bit of "wood and trees" popping in I think.. :rolleyes:


    Kind regards


    DezB

    Thanks to Rory ... and thanks for your feedback :)

    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