Hi All,

I have a table of numbers that are both negative, positive, and that can be ignored. I am trying to summarize the values at the bottom for both the largest positive and smallest negative. The problem I am having is currently it is pulling the parentheses values if they are smaller than the negative ones. Is there a way to ignore the numbers circled in parentheses all together? Thanks for any advice help i get.

Regards,
Whylucky