Google Sheets: need to dynamic formula for unique value and count multiple same value

I M trying to do some atomization in google sheet with unique and count need help please..

This is one of those cases in which it'd be better to provide links to Google Sheets documents on Google Drive than attach an Excel workbook which others would then need to upload to Google Drive.

For example, here's a link to the Google Sheets spreadsheet I created from your Excel workbook.

If you need to pull distinct values from the USERNAME column in the raw worksheet with SOLVED DATE values between the dates in the summary worksheet, you should be able to use

Formula:

=unique(filter(raw!B2:B,(raw!$D$2:$D>C$2-time(0,0,1))*(raw!$D$2:$D<C$3+1)))

If you'd also need to filter USERNAME entries in col A if summary worksheet by SOLVED BY NAME entries in cols B to D, try

Formula:

=unique(filter(raw!B2:B,(raw!$D$2:$D>C$2-time(0,0,1))*(raw!$D$2:$D<C$3+1)*countif(B20:D20,raw!$C$2:$C)))

As for counts,

Formula:

=countifs(raw!$B$2:$B,$A11,raw!$C$2:$C,B$4,raw!$D$2:$D,">"&($C$2-time(0,0,1)),raw!$D$2:$D,"<"&($C$3+1)))

and use the custom number format 0;-0;;@ , which displays nothing for 0 values.