SUMIF date criteria

  • Thread starter Thread starter CSam
  • Start date Start date
C

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
 
Hi

Try this formula:

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

Regards,
Per
 
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
 
Back
Top