SUMIF date criteria

[CSam]

Can anyone help with a Date range criteria in a SUMIF statement.
I'm trying to add up Values in line 4 between 2 dates

a b c d e f
1 start 11/11
2 end 13/11
3 dates 10/11 11/11 12/11 13/11 14/11
4 value 2 3 4 5 6
5

sumif(be:f3,">="&b1,b4:f4) will do more or = to one date how do i do a range.
Any help would be welcome


Thanks

 

[Per Jessen]

Hi

Try this formula:

=SUMIF(A3:E3,">="&A1,A4:E4)-SUMIF(A3:E3,">" &A2,A4:E4)

Regards,
Per

 

[Bernard Liengme]

How about
sumif(be:f3,">="&b1,b4:f4) - sumif(be:f3,">="&b2,b4:f4)

You should check where to use >= or >

If you have Excel 2007+ then ise SUMIFS
best wishes

 

[Ashish Mathur]

Hi,

Try this

=sumproduct((b3:f3>=B1)*(b3:f3<=b2)*(b4:f4))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com