OVH Cloud OVH Cloud

Dates

1 réponse
Avatar
Dharsh
Hi- since the english version id not working I am trying
my luck here. Can someone pls help me.

I have data in 2 columns and want to add the data in the
2nd column within a period ie within a certain date for
e.g add 2nd column between 16/03/2005 and 17/03/2005. Can
someone pls help me Pls.

16/03/2005 8
16/03/2005 8
17/03/2005 10
17/03/2005 -4
18/03/2005 5
18/03/2005 8
21/03/2005 1
21/03/2005 1

Thanks in advance

1 réponse

Avatar
Daniel
Bonjour, Hello
Essaie :
=SOMME.SI(A1:A8;"/3/5";B1:B8)+SOMME.SI(A1:A8;"/3/5";B1:B8)
Try
=SUMIF(A1:A8,"/3/5",B1:B8)+SUMIF(A1:A8,"/3/5",B1:B8)
Cordialement. Regards.
Daniel
"Dharsh" a écrit dans le message de
news: 01dd01c55191$391432e0$
Hi- since the english version id not working I am trying
my luck here. Can someone pls help me.

I have data in 2 columns and want to add the data in the
2nd column within a period ie within a certain date for
e.g add 2nd column between 16/03/2005 and 17/03/2005. Can
someone pls help me Pls.

16/03/2005 8
16/03/2005 8
17/03/2005 10
17/03/2005 -4
18/03/2005 5
18/03/2005 8
21/03/2005 1
21/03/2005 1

Thanks in advance