See the techniques here

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



In article ,
Kat wrote:

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...