Metric Sheet Countifs formula is not quite right - what am I doing wrong?

Todd101984

These first two formulas work in this Metric Sheet.

=COUNTIF({Level-ones}, $[Primary Column]@row)

=COUNTIF({Status}, [Column5]$23)

As seen by the returned values 66 and 21.

When trying to combine as COUNTIFS, it gives unparseable reply for the following formula.

=COUNTIFS({Level-ones}, $[Primary Column]@row1, {Status}, [Column3]$23)

(I also tried =COUNTIFS({Level-ones}, $[Primary Column]@row, {Status}, [Column]$23) variations and without $)

My data source for these columns:

heyjay

Can you try to remove the '1' on this arguement and see it that works:

heyjay

Can you try to remove the '1' on this arguement and see it that works:

Todd101984

I did and also the 3.

Todd101984

Oh my goodness - I tried it again and it worked. Thank you!