So I have a giant sheet where I took a bit of code to test it and it works on one sheet, but then when I piece it with the rest of the code in another sheet, it won't work. The rest of the code works fine in that sheet and even the mini code won't work on that sheet.

So I have code:

=IF(Home!S1:S151="JK", COUNTIF(Home!C1:L151, FALSE()), 0)

Basically just says hey if the values in these cells is this text, then count how many times in these corresponding cells the value false shows up. I tried a countif and countifs, didn't work because of the different size arrays.

Now my full code is:

=CONCATENATE("Gen 1: ", (IF(Home!S1:S151="JK", COUNTIF(Home!C1:L151, FALSE()), 0)), "/",(COUNTIF(C1:L151, 1)))

Basically writes out "Gen 1: ", then how many from the first part, "/", then a count in this cell .

The error code I get is "The default output of this reference is a single cell in the same row but a matching value could not be found. To get the values for the entire range use the ARRAYFORMULA function."

I'm not set in stone about using an if statement, I just couldn't figure out how to do across a large range that if this cell equals "JK", then could how many cells say false in these corresponding 10 cells of the same row without having to make a bunch of dummy variables.