LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default Sum a Filtered List excluding Negative Numbers

I wish to create a subtotal in a filtered list, which I know I could do using
the =sumproduct formula. However, I would like to know if it is possible to
exclude negative numbers from the sum. Is it possible?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Random Numbers excluding Previous Numbers Brad Excel Worksheet Functions 2 July 23rd 09 12:25 AM
Excluding Negative Numbers Workbook Excel Worksheet Functions 9 February 4th 09 01:27 PM
Set negative numbers to zero. Do not calculate with negative valu Excel Headache Excel Discussion (Misc queries) 4 September 14th 06 08:56 PM
how to change a list of possitive numbers to negative michelle Excel Worksheet Functions 1 November 16th 05 08:40 AM
how to change a list of possitive numbers to negative michelle Excel Worksheet Functions 0 November 16th 05 08:25 AM


All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"