need to count a specific number of nonblank cells that match a certain critera

I am needing to count a specific number of non blank cells.

For instance in A13 of sheet 2 I have "CC1011" . I need a count of column A ,sheet 1's non blank cells (on sheet 2) that equal "CC1011" in column D on sheet 1.

without a sample sheet I can't be entirely sure but try:

=COUNTIFS(Sheet1!A:A,"<>""",Sheet1!D:D,A13)

this formula would need to be entered somewhere in sheet2

QUESTION FOR THREAD.xlsx i'm attempting to attach a file with the question

see attached

QUESTION FOR THREAD.xlsx