COUNTIF across different spreadsheets

[Kat]

Does anyone know if it is possible to utilise the COUNTIF function across 2
or more different spreadsheets... I keep getting a value error when I try.

thanks for any help...

 

[JE McGimpsey]

See the techniques here

http://mcgimpsey.com/excel/threedsumif.html

 

[Kat]

Thanks