COUNTIFS on multiple rows, I simply can't work it out!

Hi all,

I have this formula that looks at a cell, adds a # infront and queries SHEET1 which contains the data. I need it to look at certain dates that are entered in Sheet2 C3 and C4.

The formula works for one row but I need it to query all 40 rows. IE not E3:NE3 but E3:NE42

If it can be done by using standard rather than array that would be great but not essential.

Here is the formula, It counts the #(Initials)

=COUNTIFS(Sheet1!E3:NE3,CONCATENATE("#",D8),Sheet1!E2:NE2,">="&$C$3,Sheet1!E2:NE2,"<="&$C$4)

Spreadsheet ATTACHED.

count.xlsx

Thank you, perfect.