Countif/s searching 2 criteria and 2 range and only counting if both are correct

Hi All,

I seem to be having some trouble trying to have countif/s functions that search 2 different ranges for 2 different criteria and displaying the count on a sheet only if both criteria match the search.

These are two examples i have tried using but do not work as it is only searching one range as a range, the other range is being seen as an argument.

Worksheets("Data Summary").Range("C65").Value = Application.WorksheetFunction.CountIf((Range("$U1:$U1048576"), "joeb"),(Range("$Z1:$Z1048576"), "1"))

Worksheets("Data Summary").Range("C65").Value = Application.WorksheetFunction.CountIfs((Range("$U1:$U1048576"),"joeb"),(Range("$Z1:$Z1048576"), "1"))

i will try that code in a minute.

regarding the bit you mentioned regarding the ActiveSheet only, does this still matter if the code is on the sheet itself (not in a module) and that it is called at the end of a module?

Ok that is what I thought, its all working fine now