SUMIF Multiple Specific Cells are More or Less Than X

[wonderfulsomebody123]

I know using SUMIF would work if I selected the cells with the ":" such as: G7:G106. However, I only want to sum multiple (specific) cells if they are more than X. If, for example, I want to exclude G7 because the number is negative and only sum the other cells, I run into a problem. Here's an example of what I'd like to accomplish but doesn't work:

=SUMIF(G7>=1,G16>=1,G25>=1,G34>=1,G44>=1,G52>=1,G61>=1,G70>=1,G79>=1,G88>=1,G97>=1,G106>=1)
=SUM(IF(G7>=1,G16>=1,G25>=1,G34>=1,G44>=1,G52>=1,G61>=1,G70>=1,G79>=1,G88>=1,G97>=1,G106>=1)

Right now I'm using this formula but it sums everything including the negative numbers:

=SUM(G7,G16,G25,G34,G44,G52,G61,G70,G79,G88,G97,G106)

If, for example, G7 equals -200, I want to exclude it and only sum the other cells. If G25 is negative, then exclude it also and sum only the other cells and so on...

If the cell is less than 1, how do I exclude that cell from being part of the sum?

 

[etaf]

Would G8 to G15 be greater than 1 But still excluded as you are showing non-contiguous ranges
or is there something else thats ONLY in G7,G16,G25,G34,G44,G52,G61,G70,G79,G88,G97,G106
then you could use a SUMIF ()

SUMIF(G7:G106, ">="&1)
But that will do all cells G7 to G106 that are greater than 1 not just ]
G7,G16,G25,G34,G44,G52,G61,G70,G79,G88,G97,G106


MAYBE
=SUM(SUMIF(INDIRECT({"G7","G16","G25","G34","G44","G52","G61","G70","G79","G88","G97","G106"}),">=1"))