10 Dec 2006 at 18:05 #1 PMKeates PMKeates Soldato Joined 16 Jul 2004 Posts 14,075 Consider I have a list as follows, in Excel 2007: 3 8 -5 5 -1 What formula can I use to sum this list to 16 (3+8+5)? Effectively, how do I sum only positive or negative values in Excel? Thanks in advance
Consider I have a list as follows, in Excel 2007: 3 8 -5 5 -1 What formula can I use to sum this list to 16 (3+8+5)? Effectively, how do I sum only positive or negative values in Excel? Thanks in advance
10 Dec 2006 at 18:16 #2 PMKeates PMKeates Soldato OP Joined 16 Jul 2004 Posts 14,075 Answering my own question: =SUMIF(A1:A5,">0")
11 Dec 2006 at 12:53 #3 Jonny69 Jonny69 Man of Honour Man of Honour Joined 3 May 2004 Posts 17,718 Location Kapitalist Republik of Surrey Well done, have a gold star
