# 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!