If then Statements in Excel
 

I want to create a formula that evaluates an adjacent cell for a yes
condition, if that condition is met, I want to sum to other cells, any
sugestions?
--
kyle

If then Statements in Excel
 

"Kyle" wrote:
I want to create a formula that evaluates an adjacent cell for a yes
condition, if that condition is met, I want to sum to other cells, any
sugestions?

You are more likely to get useful responses if you provide more specifics
(cell names; formulas that you tried, but they do not work for you; etc).
Otherwise, the useful of a response is the result of "dumb luck".

If the adjacent cell is B1 and the "other cells" are C1 through H1, then in
A1 write:

=if(B1="yes", sum(C1:H1), "")

The leaves the A1 appearing blank if the condition is not met.

If then Statements in Excel
 

Which other cells? Please explain what you have, and what you want to
achieve, more clearly.

Pete

On Dec 14, 8:13*pm, Kyle wrote:
I want to create a formula that evaluates an adjacent cell for a yes
condition, if that condition is met, I want to sum to other cells, any
sugestions?
--
kyle

If then Statements in Excel
 

"Joe User" <joeu2004 wrote in message ...
"Kyle" wrote:
I want to create a formula that evaluates an adjacent cell for a yes
condition, if that condition is met, I want to sum to other cells, any
sugestions?

You are more likely to get useful responses if you provide more specifics
(cell names; formulas that you tried, but they do not work for you; etc).
Otherwise, the useful of a response is the result of "dumb luck".

If the adjacent cell is B1 and the "other cells" are C1 through H1, then in
A1 write:

=if(B1="yes", sum(C1:H1), "")

The leaves the A1 appearing blank if the condition is not met.

Another interpretation, see
SUMIF Example
http://www.mvps.org/dmcritchie/excel/sumif.htm

The statement uses the word "to", keep in mind that formulas
do not change the values in other cells, you have to bring the
data to the cell with the formula.

If then Statements in Excel
 

Please enter the formula in the tab named "recent"
=IF(ROW($A2)<=COUNTIF(All!$F:$F,"?*"),INDEX(All!A: A,SMALL(IF(All!$F$1:$F$100<"",ROW($A$1:$A$100)),R OW($A2))),"")

--
Eva
Click yes if I helped

"Joe User" wrote:

"Kyle" wrote:
I want to create a formula that evaluates an adjacent cell for a yes
condition, if that condition is met, I want to sum to other cells, any
sugestions?

You are more likely to get useful responses if you provide more specifics
(cell names; formulas that you tried, but they do not work for you; etc).
Otherwise, the useful of a response is the result of "dumb luck".

If the adjacent cell is B1 and the "other cells" are C1 through H1, then in
A1 write:

=if(B1="yes", sum(C1:H1), "")

The leaves the A1 appearing blank if the condition is not met.

.