SUM Values between 2 dates and 2 times

[Sultan_392]

Hey,

I need to sum the values between two dates and times, please find the template

=SUMIFS(C:C,A:A,">="&F2,A:A,"<="&H2,B:B,">="&G2,B:B,"<="&I2)

Book1

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUM(FILTER(C2:C1000,(A2:A1000+B2:B1000>=F2+G2)*(A2:A1000+B2:B1000<=H2+I2)))