SumIF Date And Sumproduct Formula Merge

  • Greetings Formula Wizards. I need to Merge these 2 Formulas into 1 Formula. Any suggestions?


    Code
    =SUMPRODUCT((Master!$C$5:$C$50000>=DATEVALUE("1/1/2010"))*(Master!$C$5:$C$50000<=DATEVALUE("1/31/2010")),Master!$F$5:$F$50000)


    Code
    =SUM(SUMIF(Master!I5:I50000,{"Breakdowns"},Master!F5:F50000))


    Formulas are not my forte :)


    Thank you in advance for any assistance my friends.

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: SumIF Date And Sumproduct Formula Merge


    If your version of Excel supports the SUMIFS function, then try:


    =SUMIFS(Master!$F$5:$F$50000,Master!$C$5:$C$50000,">="&DATEVALUE("01/01/2010"),Master!$C$5:$C$50000,"<="&DATEVALUE("12/31/2010"),Master!$I$5:$I$50000,"Breakdowns")


    Otherwise:


    =SUMPRODUCT(--(YEAR(Master!$C$5:$C$50000)=2015),--(Master!$I$5:$I$50000="Breakdowns"),Master!$F$5:$F$50000)


    Hope this helps.

    [COLOR="Purple"]Regards,[/COLOR]
    [COLOR="Purple"]Batman.[/COLOR]

  • Re: SumIF Date And Sumproduct Formula Merge


    Thank you Sir Batman! Works perfect my friend!

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

Participate now!

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