I am using a table with different dollar amounts, both negative and positive in the same column. I understand that I can use the SUBTOTAL function to derive the sum of the numbers, however I would like to filter just the NEGATIVE numbers and make a summation of those numbers.

Ex:

15

12

13

16

-8

-22

65

Should return $30 (would like it to return a positive number if possible)

Remember, this data will be coming from filtered table out of a table.

Thanks again.