SumProduct Formula sum ="" or <1/1/2000

[drom]

Hi and Thanks in advance!
I have a Table with Dates in a Column (for tis Eg: A5:A500

• A4= DATE

If any of this cells is Empty or the inserted Date is <1/1/2000

Since 1/1/2000 is = 36526

I can Apply conditional formatting using:

• =AND(A5<>"";A5<36526)

But Now if I wanna count how many of this cells are empty or the date on them is < 1/1/2000
I was tryng to use in A2

A2 = =SUMAPRODUCTO(--((A5:A500<36526)+(A5:A500="")))
I know 3 cells are empty and only1 shows a date prior 1/1/2000 but the above formula is giving me 7

ps: I do not want to use:
=SUMAPRODUCTO(--(A5:A500=""))+SUMAPRODUCTO(--(A5:A500<36526);--(A5:A500<>""))
I am trying to learn how to apply Or Conditional fomatting for this eg

 

[Phuoc]

Try this:

=SUMAPRODUCTO(--(A5:A500<36526))

 

[drom]

Try this:

=SUMAPRODUCTO(--(A5:A500<36526))

This is gonna work only for empty cells
I am trying to sum the cells < 36526, I mean the cells < 1/1/2000 as well as the empty ones
But no duplicating the result.
=SUMPRODUCT(--(A5:A500=""))+SUMPRODUCT(--(A5:A500<36526);--(A5:A500<>"")) WORKS
But I am truing to use the OR inside the SumProduct for both case:
= ""
< 36526

 

[Fluff]

You get 7 as the blank cells are counted twice, one way is

=SUMPRODUCT(SIGN((A5:A500<36526)+(A5:A500="")))

 

[Phuoc]

Another way:

=SUMPRODUCT((A5:A500<36526)*(A5:A500>0)+(A5:A500=""))