View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Randy L Randy L is offline
external usenet poster
 
Posts: 27
Default 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! :)