Formula to ignore negative numbers in a column?
Tia,
Sum:
=SUMIF(D:D,"0")
Average:
=SUMIF(D:D,"0")/COUNTIF(D:D,"0")
HTH,
Bernie
MS Excel MVP
"Tia" wrote in message
...
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
|