Randy,

I have provided an example at http://www.HelpExcel.com/examples

The name of the spreadsheet is sum.xls
--
http://HelpExcel.com




"Randy L" wrote:

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! :)