If a cell contains a Number greater than 0

[Rich K]

I need to calculate if a range of cells contains a number greater than 1, then, to add the amount of cells that are greater than 1 and display that number of cells

Thank You

 

[Paul B]

Rich, try this, =COUNTIF(A1:A10,">"&1)

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

I need to calculate if a range of cells contains a number greater than 1,

then, to add the amount of cells that are greater than 1 and display that
number of cells.

 

[Peo Sjoblom]

=SUMIF($A$3:$A$12,">1")

to sum

and

=COUNTIF($A$3:$A$12,">1")


to count

if you want to display the cells, assuming you have a header in A2, put the
name of the header in for instance D1 and in D2 put >1, select the list
header included
do data>advanced filter, select as criteria D12 and the whole list as
range, copy to another
location, select where you want it and click OK

--

Regards,

Peo Sjoblom

I need to calculate if a range of cells contains a number greater than 1,

then, to add the amount of cells that are greater than 1 and display that
number of cells.

 

[Guest]

-----Original Message-----
I need to calculate if a range of cells contains a

number greater than 1, then, to add the amount of cells
that are greater than 1 and display that number of cells.

Thank You
.Use the count if function where you want to displaythat

number of cellsexample =COUNTIF(B5:B12,">1")this will
count the # of cells greater than 1 in cells b5 through
B12. Good luck