Countif (with two criteria from another sheet)

I'm try to count only if rows from another sheet match two criteria in two columns.

The sheet is Findings list, and the columns are below.

What am I doing wrong?

=COUNTIFS({Findings List Range 2}:{Findings List Range 2}, <>"Complete" , [{Findings List Range 1}]:[{Findings List Range 1}], <Today())

Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    OOOOH. And the cross sheet formulas shouldn't be in a range themselves.

    =COUNTIFS({Findings List Range 2}, <>"Complete" , {Findings List Range 1}, <Today())

    I don't use them often enough to notice but your final result should look like that.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!