Hey guys, I found this wesite forum very useful in the last little while so I ended up signing up for the forum. I have a question that have been driving me nuts in the last week or so. I cannot figure it out at all. Basically I need to do a summation in excel (ie. sigma). Here is my problem. My formula is sigma(X-10). What I need is a formula that allows me to take values form a list of values and keep adding them into X and sum them at the end. Also while I am summing I want all negative numbers from my list of values excluded form my summation. Is there anyway that excel can compute this without having to do it all manually cell by cell. Iother words compute everthing in one excel and give me my final answer. Thanks!! Brent
