 |
07-05-2007, 11:38 PM
|
#1 | ||
|
College Benchwarmer
Join Date: Oct 2000
Location: Louisiana
|
Need help with an excel formula...
I'm working on a table, and I need to get the sum of some numbers, but only for the numbers that are positive.
I've checked and can't seem to find this in excel- does this exist? Example: 5 6 8 4 1 -6 -4 4 -3 2 I'd simply want the sum of the positive numbers, so in this case...30 |
||
|
|
|
07-05-2007, 11:44 PM
|
#2 |
|
High School JV
Join Date: Oct 2000
|
Assuming your list of numbers resides in column A, your formula would be...
Code:
|
|
|
|
|
07-05-2007, 11:45 PM
|
#3 |
|
College Prospect
Join Date: Jul 2001
Location: Newcastle, Australia
|
There is a SUMIF option.
=SUMIF(A1:A10,">0") |
|
|
|
|
07-05-2007, 11:46 PM
|
#4 |
|
College Prospect
Join Date: Jul 2001
Location: Newcastle, Australia
|
I knew that would happen...
 |
|
|
|
|
07-05-2007, 11:46 PM
|
#5 |
|
College Benchwarmer
Join Date: Oct 2000
Location: Louisiana
|
ah- there we go, thanks for the quick responses. I had the =sumif(C12:C48, but was confused on the last part
|
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
|
|
