error trying to use vba countifs function

I have two workbooks

i have this code which gives me an error

Junk1 = Application.WorksheetFunction.CountIfs( _
study_number_range, Workbooks("To_be_used_with_macro1_doc1.xlsm").Worksheets("Sheet1").Range("A2"), _
Received_col_range, "<>" & "", _
Closed_col_range, ">=" & start_date1, _
Closed_col_range, "<=" & end_date1)

any idea why it does not work?

they are ranges........see code below

Set Received_col_range = Workbooks(wrkbookname1).Worksheets(wkrsheetname1). _
            Range(alphacol(Received_Col) & "2:" & alphacol(Received_Col) & (last_row1 + 1))
                                                                    
Set study_number_range = Workbooks(wrkbookname1).Worksheets(wkrsheetname1). _
            Range(alphacol(1) & "1:" & alphacol(1) & (last_row1 + 1))
                                                                    
Set Closed_col_range = Workbooks(wrkbookname1).Worksheets(wkrsheetname1). _
            Range(alphacol(Closed_Col) & "2:" & alphacol(Closed_Col) & (last_row1 + 1))
                                                                    
'Set study_1_range = Workbooks("To_be_used_with_macro1_doc1.xlsm").Worksheets("Sheet1").Range("A2")

                                                                    
'Total closed
Junk1 = Application.WorksheetFunction.CountIfs( _
study_number_range, "=" & Workbooks("To_be_used_with_macro1_doc1.xlsm").Worksheets("Sheet1").Range("A2").Value, _
Received_col_range, "<>" & "", _
Closed_col_range, ">=" & start_date1, _
Closed_col_range, "<=" & end_date1)

ok...not sure why but i changed the set ranges all the same starting point.....some were 1 and some were 2..........changed all starting points of the ranges to "1" and it works......i think........

Set Received_col_range = Workbooks(wrkbookname1).Worksheets(wkrsheetname1). _
            Range(alphacol(Received_Col) & "1:" & alphacol(Received_Col) & (last_row1 + 1))
                                                                    
Set study_number_range = Workbooks(wrkbookname1).Worksheets(wkrsheetname1). _
            Range(alphacol(1) & "1:" & alphacol(1) & (last_row1 + 1))
                                                                    
Set Closed_col_range = Workbooks(wrkbookname1).Worksheets(wkrsheetname1). _
            Range(alphacol(Closed_Col) & "1:" & alphacol(Closed_Col) & (last_row1 + 1))
                                                                    
'Set study_1_range = Workbooks("To_be_used_with_macro1_doc1.xlsm").Worksheets("Sheet1").Range("A2")
'Workbooks("To_be_used_with_macro1_doc1.xlsm").Worksheets("Sheet1").Range("A2").Value
                                                                    
'Total closed
Junk1 = Application.WorksheetFunction.CountIfs( _
study_number_range, "=" & Workbooks("To_be_used_with_macro1_doc1.xlsm").Worksheets("Sheet1").Range("A2").Value, _
Received_col_range, "<>" & "", _
Closed_col_range, ">=" & start_date1, _
Closed_col_range, "<=" & end_date1)

thanks.......for your help.