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-sheetCOUNTIFS formulashould 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 (seethis articlefor more information).

Then I used theOR functionto 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 functionas 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-sheetCOUNTIFS formulashould 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 (seethis articlefor more information).

Then I used theOR functionto 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 functionas 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