Using Filter Function to IGNORE #N/A

[Howardc1001]

I have set up a filter formula to extract Data based on specified item

However I have $N/A items in the data and need Filter to exclude these when generating a result

Please Login or Register  to view this content.

I have attached sample Data

It would be appreciated if someone could kindly amend my formula

[wk9128]

Cell O6 formula

Please Login or Register  to view this content.

[Bo_Ry]

Please try

=FILTER(FILTER(A2:H8,COUNTIFS(O5:Q5,A1:H1)),IFNA(H2:H8,)=Q2)

[Howardc1001]

Many thanks for the help Guys. Formula works perfectly

[wk9128]

@Howardc1001 You're Welcome. Glad to help . Thank You for the feedback