Counting Unique Values in an array, excluding counts past today's date

Hi, i am trying to track open proposal activity for our suppliers..
Currently i'm able to count active RFP's per supplier but not with a date criteria..

"pending awad" tab, Columns T - X are bidders for a particular project. column Z is the bid due date.
i want to be able to "count" subcontractor activity, tab "subk RFP activity" in relation to date.. how many are active past today's date, how many between 2 dates?

any ideas? thank you!

T3:X10004 and Z3:Z10004 aren't the same size, but they are conforming (they share the same number of rows), which means NOT a job for COUNTIFS but a job for SUMPRODUCT.

In worksheet Subk RFP Activity, if I3 were a single date after which you want a count,

I4: =SUMPRODUCT(('pending award'!$T$3:$X$10004=$E4)*('pending award'!$Z$3:$Z$10004>I$3))

If K2 were a beginning date, K3 and ending date, and you wanted an inclusive count between those dates

K4: =SUMPRODUCT(('pending award'!$T$3:$X$10004=$E4)*('pending award'!$Z$3:$Z$10004>=K$2)*('pending award'!$Z$3:$Z$10004<=K$3))

In both cases, fill the row 4 cell down into rows 5 to 16.

oh my gosh thank you!!! i should've posted earlier, would've saved me hours. thank you!

can you help with one more thing?
how do i combine multiple values into a single cell?

i tried the textjoin formula but it's erroring out..

in subk RFP activity tab, cell H4, i wanted to list all the "req numbers" in one cell after searching the winning bid column.
so cell H4 should say REQ10007.
Cell H5 would say REQ10004, REQ10012.

let me know.. thank you again! last question

thank you again! really appreciate it

ugh thanks again..
i tried researching these 2 questions below but it kept giving me an error so here i am again..

You know before you provided a sumproduct formula to count the number of "active bids" in an array after a specific date?
and you also helped pull text data into a single cell for the "winning bid" suppliers?

1. Are we able to pull the same data out of the pending award tab, columns T:X, to show bid number and bid description into single cells on the subk RFP activity tab? columns E and F?
2. what is the formula code to separate information by new row vs. comma?
in the formula you provided, it separates the consolidated cells by comma. i tried various formulas, mostly with ampersands but couldnt get to work..

also, i have TEXTJOIN in excel so i guess i have 2016 at least.