I need help with my formula for pacing

I am trying to create a formula that will provide a running total based on if an ad is running during a specific date. I believe I have the first part correct where I take the total run during the time period stated and divide it by the total number of days during that period.

I am stuck on creating a formula that says look to see if the date is between the start and end date and if it is ad it to the sum. Someone showed me how to do this with an array formula a long time ago but I cant quite get it to work.
This is one of my attempts: =IF([@[Start date]]<=[@Date]>=[@[End date]],SUMIF(A:B,[@Date],C:C),0)

EXCEL FILE: https://drive.google.com/file/d/0ByV...ew?usp=sharing

Hi, welcome to the forum

Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

From the sounds of it, take a look at using countifS()

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I think this is teh formula you want...
=SUMIFS($C:$C,$A:$A,">="&Sheet1!$F3,$B:$B,">="&Sheet1!$F3)

If you only want the total shown once, modify it to this...
=IF(COUNTIFS($A$1:A1,">="&Sheet1!$F3,$B$1:B1,">="&Sheet1!$F3)>1,"",SUMIFS($C:$C,$A:$A,">="&Sheet1!$F3,$B:$B,">="&Sheet1!$F3))