I can't believe nobody has had this issue before but i cant find it on the web.
I have a table with 6 columns. In the 5th column i want to add a formula which says: check how many columns there are after column 6 (F) and then do a countif if any of them say "x".
i cannot figure this out. I know it should be simple but its got me stumped. Please help.