Sum a value

[Jafferi]

How do I plant in a formula to sum up 1 Mar

Example:
C D
1 Mar -> How do I fomulate this cell to sum cell B to equal to $12

A B
Date $
1 Mar 5.00
1 Mar 7.00
2 Mar 5.00
2 Mar 2.00

 

[Mike H]

Hi,

With the date to sum in C1 try this

=SUMIF(A2:A20,C1,B2:B20)

Mike