Forum Discussion
joeyc380
Jul 08, 2021Copper Contributor
Can Excel =filter function include a 'criteria range' for multiple criteria of one column?
Hello Everyone, I am trying to use =filter formula to filter multiple criteria for a single column as below, by using a "criteria range": However it is not working and return an #N/A ...
- Jul 08, 2021
PeterBartholomew1
Jun 28, 2025Silver Contributor
An alternative using COUNTIFS.
= FILTER(table, COUNTIFS(selected, column1))