Counting Dates in a column of data

[DHBarkley]

Good day All,

You have been most helpful in the past and I have run into another problem. I need to only count dates in a column of various data that meet certain criteria in 2 other columns. Here is what I have:

=SUMPRODUCT(--(X19:X1001<>"")*(B19:B1001="SV / P1")*(E19:E1001="ZONE 4"))

I cannot figure out how to only count the dates in column X and nothing else.

 

[MrKowz]

You can't use the double unary operator and the multiply operator in the same sumproduct like that:

=SUMPRODUCT(--(X19:X1001<>""),--(B19:B1001="SV / P1"),--(E19:E1001="ZONE 4"))
​

 

[Jonmo1]

Perhaps use ISNUMBER instead of <>""

Try

=SUMPRODUCT(ISNUMBER(X19:X1001)*(B19:B1001="SV / P1")*(E19:E1001="ZONE 4"))

 

[DHBarkley]

Jonmo1,

That worked perfectly. As always, this forum has come through. Thanks.