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