PC Review


Reply
Thread Tools Rate Thread

how can I add +ve numbers only in a list of +ve and -ve numbers

 
 
Paul
Guest
Posts: n/a
 
      10th Dec 2007

 
Reply With Quote
 
 
 
 
T. Valko
Guest
Posts: n/a
 
      10th Dec 2007
=SUMIF(A1:A10,">0")

--
Biff
Microsoft Excel MVP


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2007 - How to replace hardcoded numbers with list numbers? KerryL Microsoft Word Document Management 1 8th Oct 2009 10:28 PM
Query only numbers out of a list with letters and numbers Aaron Microsoft Access Queries 3 5th Oct 2009 03:23 PM
how to extract unique numbers once from a list of repeated numbers? stuart.kwok@gmail.com Microsoft Excel Misc 2 2nd May 2006 04:17 PM
Create an index with page numbers and list numbers =?Utf-8?B?QXRvbW9z?= Microsoft Word Document Management 1 16th Aug 2005 11:39 AM
Excel checking numbers against a large list of numbers =?Utf-8?B?TWF4b24=?= Microsoft Excel Worksheet Functions 2 24th Sep 2004 11:40 AM


Features
 

Advertising
 

Newsgroups
 


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