Test of data in rows

I have a set of data where column name is month and cells in columns under each month have a quantity in them. The number can be positive, negative, zero or null. I want to look at one column and first test if it has a negative number, second, test the rest of the values in the row to see if there is a positive number in any of the columns. So for simplisity, let's start with four columns and three rows of data.

May. June. July. August

5. 0. Null. Null
Null. Null. Null. Null
10. -10. Null. 2

I want to be able to test for the negative occurance first in June, then compare that to the sum of the rest of the cells in that row and if the total of the sum of all cells is zero or greater than the negative number, flag it.