View original (French)

Sum.if.ens criteria between two dates

Solved
texas4229 Posted messages 2 Status Member -  
 Ariel7 -
Hello,

I have a column in an Excel sheet with dates (A2:A13) and another one with the expenses for those days (B2:B13).
I would like to sum the expenses in F2 with two date boundaries as criteria (D2 start date and E2 end date).
After consulting many forums, I can't find the correct formula...
The one I am using displays 0:
=SUMIFS(B2:B13,A2:A13,">=D2",A2:A13,"<=E2")

Thank you for your help.



Excel 2007 or 2010

1 answer

  1.
    Mytå Posted messages 4246 Registration date   Status Contributor Last intervention   957
     
    Hello Forum

    The formula 
    =SUMIFS(B2:B13,A2:A13,">=" & D2,A2:A13,"<=" & E2)

    Mytå
    --
    Thank you for following up on your question, we are not robots...
    “If debugging is the art of removing bugs, then programming must be the art of putting them in.”
    114
    1. clementV
       
      Thank you, this formula is much better than "sumproduct"!!!!
      2
    2. Ariel7
       

      Thank you very much for this wonderful formula.

      1