If then Statements in Excel

  • Thread starter Thread starter Kyle
  • Start date Start date
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?
 
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.
 
Which other cells? Please explain what you have, and what you want to
achieve, more clearly.

Pete
 
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.
 
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))),"")
 
Back
Top