Hi,
suppose that your dates are in column A starting in row 2, the amount to be
sum in column B and the day entered for what you want the sum is in cell C1
so in D1 enter

=SUMPRODUCT(--(c1=A2:A100),B2:B100)

change the range to fit your needs

"Ellie Sarmadi" wrote:

Help pls!
Need a formula to do the following:

if date in range matches date in a cell then sumif function... the
formula doesn't take the if fucntion relating to date in account...

-ellie