Formula to show 'Reject' number and type

I’m looking for formulas to populate “Times Rejected/Canceled” and “Rejected at Queue” Columns B & C in Report worksheet based on the data available in Queue worksheet.

Refer to the attached file, In the Report sheet, Column B gives you the number of times “Reject” or “Cancel” shows up against the ID and Column C gives you the Queue’s at which they were Rejected or Canceled.

Appreciate any help. Thanks!