COUNTIFS formula for criteria in two columns in another sheet not working

SarahBKarna

I am counting how many ads are live out of how many total and I'm unable to get the COUNTIFS formula to work. The cell should reference another sheet and count how many ads are live in each category.

The formula I'm using is coming up unparesable even though I referenced Smartsheet's many help pages on this topic. What am I doing wrong?

=COUNTIFS({6. Ad Placement Tracker Range 1}:{6. Ad Placement Tracker Range 1}, 1, {6. Ad Placement Tracker Range 2}:{6. Ad Placement Tracker Range 2},"eNewsletter"})

Paul Newcome

When using a cross sheet reference, you only enter it once.

=COUNTIFS({Cross Sheet Reference}, @cell = "Text")

When you set up the cross sheet reference, you would click on the column header to select the entire column and that is built into the reference automatically.

Paul Newcome

When using a cross sheet reference, you only enter it once.

=COUNTIFS({Cross Sheet Reference}, @cell = "Text")

When you set up the cross sheet reference, you would click on the column header to select the entire column and that is built into the reference automatically.

SarahBKarna

@Paul Newcome THANK YOU!

Paul Newcome

Happy to help. 👍️