I'm trying to sum the number of sales by product type in a previous year up to and including todays date, ignoring the year. So I want to get todays date automatically, remove the year and

and count the number of sales to 15 Jan for example.

I have this formula, which counts by product type, upto the current date, which is wrong. Can't figure out how to just use the day & Month.

=SUMIF(A1:E1,"<="&TODAY(),A2:E2)

Many thanks