Summing up values given a certain date

[hi0805]

Hello all,

I am trying to add up the value in column B given a certain date. The table is as follow:

	A	B
1	5/2/2015 11:18:00 PM	100
2	5/2/2015 9:44:00 PM	100
3	6/2/2015 2:26:00 PM	200
4	6/2/2015 4:53:00 PM	200
5	6/2/2015 6:18:00 PM	200

The sum result table:

5/2/2015	200
6/2/2015	600

I used the formula: =SUMIF(A:A, "*5/2/2015*", B:B) and =SUMIF(A:A, "*6/2/2015*", B:B) , but they don't seem to work. If you guys could please help that would be great.

Thank you very much in advance.

[zbor]

Use Pivot table

[hi0805]

Is there anyway I can use a formula to do this please?

[FDibbins]

Try this, copied down...
=SUMPRODUCT((INT($A$1:$A$5)=A8)*($B$1:$B$5))

[hi0805]

Thanks for the reply. If I would like to add an extra criteria into the table. What should I do please?

	A	B	C
1	5/2/2015 11:18:00 PM	N	100
2	5/2/2015 9:44:00 PM	B	100
3	6/2/2015 2:26:00 PM	N	200
4	6/2/2015 4:53:00 PM	B	200
5	6/2/2015 6:18:00 PM	N	200

The sum result table:

5/2/2015	N	100
6/2/2015	N	400

Thank you for all the help in advance.

[FDibbins]

=sumproduct((int($a$1:$a$5)=a8)*($b$1:$b$5="n")*($c$1:$cb$5))

[hi0805]

Thanks for your help

[FDibbins]

Glad it worked for you