How to do a complex filter

[amartino44]

I have column A with "Keywords" and then in column B, C, D, I have numbers for three products. How can I filter out any rows where the values are ALL "NA" for all three products.

[63falcondude]

I would create a helper column in say column E using this formula in E2:

=COUNTIF(B2:D2,"NA")=3

Then you can filter column E for TRUE.

If the values are #N/A, you would use NA() instead of "NA".