getting total from column if todays date is equal to or greater than date column

Hi All,

I need some help with getting a total from a column (new customers) only if todays date is equal to or greater than my date column (w/e sunday)

in the attached jpeg i have put formula in b1, but this is only for 1 date as i get errors what ever i try to get this to work :/

if this was working correctly then b1 should be showing 3 and on the 15th dec it should be 6

is there a way of doing this?

yes, great

thankyou very much