Selective addition based on criteria
I have a column of information that contains various numerical entries.
I want to sum the entries to get a total. The entries are both positive and
negative numbers.
If an entry contains the value -250, I want to sum only the negative values
(including the -250 and any other possible -250 entries) omitting any
positive entries. Otherwise it will sum both negative and positive values.
Thank you for your assistance! :)
|