ExcelBanter - Countif

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Countif (https://www.excelbanter.com/excel-programming/338767-countif.html)

Davor ®upaniæ

Countif

How to merge (expand) range criteria for COUNTIF outside the sheet1.

=COUNTIF(C:C+[737.xls]Sheet1!$C:$C;C4)

That is not working.

How to fix that?

Rowan[_4_]

Countif

Maybe

=COUNTIF($C:$C,C4)+COUNTIF('[737.xls]Sheet1'!$C:$C,C4)

Regards
Rowan

"Davor Â®upaniÃ¦" wrote:

How to merge (expand) range criteria for COUNTIF outside the sheet1.

=COUNTIF(C:C+[737.xls]Sheet1!$C:$C;C4)

That is not working.

How to fix that?

All times are GMT +1. The time now is 09:52 AM.