Hello forum, thanks in advance for the help.
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.
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.