Check a column for >0 then put results to a desired cell location

[nicksenior]

I知 a senior with an excel problem. I知 trying to search a column that has a value >0 then move it to a different cell so I can perform other calculation using that cell. The column cell containing the data, I want to use, might change its cell location but not column location. The data is derived for another set of calculations.
I知 not a programmer so, please make it easy for a dummy to understand.


Any/All Help is appreciated,

Nick Senior

[AlKey]

You can try something like this

in B1

=IF(A1>0,A1,"")

or if you need to sum values greater than 0:

=SUMIF(A1:A5,">0")

	A	B
1	0
2	-5
3	-4
4	3	3
5	1	1

[nicksenior]

Thank You. Can I add to this formula so, it allows me to put the results, it will only be one, into a desired cell location so, I can do some additional calculation using the result put into the desired location?

Nick Senior.

[nicksenior]

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#1 and amend your title
Then anyone will be able to help you.

"I should have changed my title to explain what I was looking to do."