specifying a workbook in excel functions

[ashagplz]

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.

 

[Grrrrr]

=countif(range, criteria)

So for range you need '[C:\Users\ashagplz\Desktop\example.xls]Sheet1'!$A$1:$A$10 note the square brackets, apostrophes and exclamation mark.

For criteria you could use a number, e.g. typing 17 would count the number of times 17 appears in the range. Or you can use a cell reference, typing D2 would count the number of times the value in D2 appears in the range