Sum between two dates
maman303
Posted messages
1
Status
Membre
-
ccm81 Posted messages 11033 Status Membre -
ccm81 Posted messages 11033 Status Membre -
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
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 réponses
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
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."
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."