If then Statements in Excel

K

Kyle

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?
 
J

Joe User

Kyle said:
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?
Click to expand...

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.
 
P

Pete_UK

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

Pete
 
D

David McRitchie

Joe User said:
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.
Click to expand...

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.
 
E

Eva

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)),ROW($A2))),"")
 
Top