Formula to ignore negative numbers in a column?
Try something like this:
With values in cells A1:A10
Greater than zero:
SUM
B1: =SUMIF(A1:A10,"0")
AVERAGE
B2: =SUMIF(A1:A10,"0")/COUNTIF(A1:A10,"0")
Greater than or equal to zero:
SUM
B1: =SUMIF(A1:A10,"=0")
AVERAGE
B2: =SUMIF(A1:A10,"=0")/COUNTIF(A1:A10,"=0")
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Tia" wrote:
I have a lengthy spreadsheet with several columns of numerical data. Some
cells have positive numbers and others have negative numbers. My goal is to
get both a column sum and average--but only of only those cells with a
positive number--i would like to exclude the negative numbers from my
calculations.
Are there formulas that will so this for me?
--
Tia, Education and Documentation Specialist
|