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

"CSam" skrev i meddelelsen
...
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

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
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"CSam" wrote in message
...
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

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"CSam" wrote in message
...
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