View original (French)

Sum between two dates

maman303 Posted messages 1 Status Member -  
ccm81 Posted messages 11033 Status Member -
Hello,

I am desperately looking for a formula to display a sum on a table when it falls between two dates, and this obviously for several months.
For example: I would like the sum to appear in a cell if the date is between 01/08/14 and 31/08/14, and another sum to appear if it is between 01/09/14 and 30/09/14. If there could be just one formula, that would be extraordinary ;-).

Thank you for your responses.

maman303

2 answers

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

    The date 01/09/2014 is in cell A1
    The date 30/09/2014 is in cell A2
    The dates are in column C and the range to sum is in column D 

    SUMIFS(D:D;C:C;">"&A1;C:C;"<"&A2)

    Mytå

    Thank you for responding to your question, we are not robots...
    "If debugging is the art of removing bugs, then programming must be the art of creating them."
    1