ExcelBanter - COUNTIF across different spreadsheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COUNTIF across different spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/213134-countif-across-different-spreadsheets.html)

Kat

COUNTIF across different spreadsheets

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

--
Kat

JE McGimpsey

COUNTIF across different spreadsheets

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

Kat

COUNTIF across different spreadsheets

Thanks

--
Kat

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

--
Kat

All times are GMT +1. The time now is 06:54 PM.