Ignoring text values in a SUMPRODUCT(--(YEAR formula

[ExcelPoser]

Hi all, I'm trying to design a spreadsheet to report on the number of project submissions my team has made over the course of the year, and also how many submissions were made over the course of the year for different stakeholders.

The thing is, some projects can be cancelled, but we still need to track that activity so in some cases you will have text in the submission date section saying "cancelled" or something along those lines.

Obviously this is creating the #value error and I'm struggling to make it ignore text. I'm trying to use IFERROR but that creates a massive spill.

Here is my original formula:

=SUMPRODUCT(--(YEAR(_Activity[[Date Submitted]:[Date Submitted]])=$A$1),--(_Activity[[Brand]:[Brand]]=C$6))

How can I make this ignore text values in the date submitted column?

 

[BSALV]

Map1
	A	B	C	D
1	date submitted	brand		3
2	14/02/2022	a
3	14/02/2022	b
4	14/02/2022	a
5	14/02/2022	c
6	cancelled	a
7	14/02/2022	d
Blad3

Cell Formulas
Range	Formula
D1	D1	=SUMPRODUCT(--IF(ISNUMBER(Tabel1[date submitted]),YEAR(Tabel1[date submitted])=2022,Tabel1[date submitted]="cancelled"),--(Tabel1[brand]="a"))