View original (French)

Sum.if.ens criteria between two dates

Solved
texas4229 Posted messages 2 Status Membre -  
 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 réponse

Réponse 1 / 1
Mytå Posted messages 4246 Registration date   Status Contributeur 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
clementV
 
Thank you, this formula is much better than "sumproduct"!!!!
2
Ariel7
 

Thank you very much for this wonderful formula.

1