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