Excel Formula to SUMIF date falls in particular range of dates -

what i'm trying create excel file our company's stores can use track newspaper returns , sales.

we further use file here @ hq reconciling invoices on monthly basis when sent us.

the tables i'm using have following data:

        b        c                  d 

1) 07/30.....$1.90.....formula

2) 07/31.....$1.60.....formula

3) 08/01.....$2.10.....formula

4) 08/02.....$5.60.....formula

5) 08/03.....$4.70.....formula...... weekly total(=sum(b2:b?)

etc etc etc etc

in example, store managers track received papers , returned papers totaled cost give data (extended cost) in column b. excel file ongoing, never ending list of values organized date in form of weekly blocks, subtotal each week in column d. managers need column weekly totals, weeks don't necessary coincide nicely. (i.e. may have totals august , september in 1 week's block)

i'm using following formula calculate monthly totals in hidden column e (these calendar month totals run 1st of month 31st of month easy do):

• formula

=if(month(c5)<>month(c5+1),sum(h$5:h5)-sumif(c$5:c5,"<"&date(year(c5),month(c5),1),h$5:h5),"")

that works great, gives me running total calendar month of 1st through end of month. eliminates previous monthly bills using sumif formula toward end of formula. problem i'm having trying recreate newspaper not run on set calendar month. invoice, instead, billed 16th of month through 15th of next month.

the invoices other paper typically start on 16th of month , end on 15th of following month. need formula (hopefully similar 1 mentioned using earlier can understand how works) sum given date range (i.e. 06/16/14 - 07/15/14) won't show outside of date range, though data giant list.

i wish post images (need @ least 10 reputation) make explanation 10 times easier, won't allow me so.

if understand question correctly, should able use sumifs set multiple conditions date column. assume c date column while h daily sales column.

=if(day($c5)<>15,"",sumifs($h:$h,$c:$c,"<="&date(year($c5),month($c5),15),$c:$c,">="&date(year($c5),month($c5)-1,16)))

the above formula add values 16th of previous month , including 15th of current month. cells day not equal 15 blank.

i tested on blank worksheet year's worth of sequential dates in column c , random currency values in column h, formula in every cell in column i. should work purposes unless there's piece of puzzle i'm missing, speak. let me know if works you!