suppose i have a workbook called example.xls.
I want to make a countif to count all the times a criteria is met on any any worksheet. how do i specify the workbook within the function?
=COUNTIF(example.xls,A1)
a1 being the cell to place the result.
Cheers.
I want to make a countif to count all the times a criteria is met on any any worksheet. how do i specify the workbook within the function?
=COUNTIF(example.xls,A1)
a1 being the cell to place the result.
Cheers.