Google-sheets – COUNTIF to display which results meet criteria

formulasgoogle sheets

I'm working on a spreadsheet, where I'm using COUNTIF to check the number of times a sheet range meets a criterion. This works.

I'd like to see which cells (their contents/locations) which met the COUNTIF criteria.

Specifically, the cells are strings not numbers.

Best Answer

  • if you need formula solution use ARRAYFORMULA():

    =ARRAYFORMULA(IF(A1:A10<5,TRUE,FALSE))

    enter image description here

Related Topic