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?

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.

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))),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top