Filtering based on multiple columns

I'm not sure that's a valid Numbers formula!

Could you post a screenshot?

(Shift-command-4, drag to select area, release, start new post here and use the mountains-and-moon 'Image insertion' icon beneath the compose window to attach a screenshot from the Desktop.)

Note that things are much easier in Numbers if you reference the entire column F (rather than the Excel-like $F$2:$F$201).

Note that you can use the SUBTOTAL function to perform STDEV_H and other operations that skip rows that are hidden (manually or by applying a filter, for say, 1, on multiple columns).

SUBTOTAL - Apple Support

Filter data in Numbers on Mac - Apple Support

That may be a more natural way to accomplish what you are trying to do.

SG

Excel has "array" formulas that can let you "filter" data and create a subset array of the data within the formula. Numbers does not have that. If you want a subset of the data, you need to do it in the table, usually with an extra column. Your formula does not look like a correct array formula for Excel. It looks like like it would insert a bunch of 1's and FALSE's into your data set in Excel. In Numbers it will look at the value in column E that is in the same row as the formula and insert a single 1 or FALSE.

The typical way to create a subset of data is to use a new column.

Column G formula = IF(E,F,"")

Then use STDEV(G).

Another way you can do it for a few functions, including STDEV, is with filtering and the SUBTOTAL function.

=SUBTOTAL(107,F) will use only the visible rows in column F. If you put a filter on the table to hide the rows you do not want included, those hidden rows will not be included.