Countifs with Multiple Criteria and Referencing Another Sheet

Thu Nghiem

Hi! I am trying to create a formula that will count the cell if column X (checkbox type) is checked and comlumn Y has "N "or is blank. I would like it to total on my metric sheet so I can generate a graph off of the data, therefore, the formula will be referencing this information from another sheet.

Hope makes sense!

Thank you!

Thu

Genevieve P.

Hi Thu,

Sounds like a cross-sheet COUNTIFS formula should work for you!

Try this:

=COUNTIFS({Column x}, 1, {Column Y}, OR(@cell = "N", @cell = ""))

The references {in these} would be Cross Sheet References that you would insert by selecting the correct column in the other sheet (see this article for more information).

Then I used the OR function to specify that there are two different values in Column Y that should be counted with the criteria for Column X. Finally, within OR I used the @cell function as the range to search through (search through each individual cell in the previously stated range). The two quotes "" indicate that the cell is blank.

Let me know if you have any questions about this, or if it works for you! If it didn't work, it would help to see screen captures of your two sheets, and a screen capture of each reference when you select it in the pop-up window. (But please block out any sensitive data in the screen captures!)

Cheers,

Genevieve

Genevieve P.

Hi Thu,

Sounds like a cross-sheet COUNTIFS formula should work for you!

Try this:

=COUNTIFS({Column x}, 1, {Column Y}, OR(@cell = "N", @cell = ""))

The references {in these} would be Cross Sheet References that you would insert by selecting the correct column in the other sheet (see this article for more information).

Then I used the OR function to specify that there are two different values in Column Y that should be counted with the criteria for Column X. Finally, within OR I used the @cell function as the range to search through (search through each individual cell in the previously stated range). The two quotes "" indicate that the cell is blank.

Let me know if you have any questions about this, or if it works for you! If it didn't work, it would help to see screen captures of your two sheets, and a screen capture of each reference when you select it in the pop-up window. (But please block out any sensitive data in the screen captures!)

Cheers,

Genevieve

Thu Nghiem

That worked perfectly!! THANK YOU SO MUCH! (And thank you for the explanation and extra resources!) 😊

Thu

Genevieve P.

No problem at all! Glad it worked for you 🙂