[Dropped] Check separate columns for values

[Lt2210]

I want to check specific columns in a row to see if they have a value ">0" entered. In my table, I want to check B6, M6, V6, and 20 other cells in the row, to see if they have a value >0 entered while ignoring the other cells in the row. (So listing a range of B6:Z6 doesn't work). I can't seem to find the right syntax.

[Lupp]

Welcome!

... to find the right syntax.

Why do you think there is one?
There is a toolbox of standard functions for which parameters and working are specified.
But you can always ...
1) find a problem that can simply not be solved using Calc.
2) have chosen a design for spreadsheets which is unsuitable for the task.

How should I (we) know without having your sheet(s) at hand and knowing nothing about the task you want to get done by them?

Needing to refer to arbitrarily scattered cells is suspected to be the consequence in case of 1) or 2).

You may describe your problem clearly. Best you attach an example document showing what you have and what you already tried. However, there is no formula that can handle any arbitrary set of cell references.