Conditional SUMIF statement

[kylewent]

I am having some issues with a conditional SUMIF statement. Here are the details. The statement below currently works.

Contents of K14
=IF(J14="Yes",F14,IF(A14<>A13,SUMIF(A:A,A14,F:F),""))

Column A are Dates in chronological order
Column F is a $ amount.
Column J is "Yes" or blank. If Yes the value passes through to K "as is".
Column K are subtotals of values in Column F.

K14 above subtotals all items in F where dates in A are the same.
However, I need the calculation to exclude the value in F if J="Yes".

Thanks for the help.

Kyle

 

[kylewent]

See next post.

 

[kylewent]

Here is a shot of the page.

Thanks,
Kyle