sumif where date is empty or later than today

[mrconfused2]

Hello,

I have two columns. A with date, B with numbers. Both have several lines of headers. I want to sum the cells in B where the corresponding cells in A are either empty or have a future date. How?

Thank you,

 

[VoG]

Try

=SUMIF(A2:A15,"",B2:B15)+SUMIF(A2:A15,">"&TODAY(),B2:B15)

 

[mrconfused2]

Thank you

I get a #VALUE!

Could it be that the problem is the date cells are strings?

 

[balajayan]

Please try the following

=SUMPRODUCT(--(ISBLANK(A1:A700)),B1:B700)+SUMPRODUCT(--(A1:A700>TODAY()),B1:B700)

 

[VoG]

That is the problem.

Can you give some examples of your text dates.