I have created this "if" statement.
=IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0",
IF(G17=(166718),"1", IF(G17=(166685),"4", IF(G17=(166745),"0", IF(G17=(""),""
)))))))

Now i want to add the result of this statement from consecutive rows.
i did sum on the results but i am not able to add the results of my
statements.

can you tell me how i can add the results of this statement?

Try it like this

=IF(G17=(166719),1, IF(G17=(165852),2, IF(G17=(165851),0,
IF(G17=(166718),1, IF(G17=(166685),4, IF(G17=(166745),0, IF(G17=(""),""
)))))))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Xiamen" wrote:

I have created this "if" statement.
=IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0",
IF(G17=(166718),"1", IF(G17=(166685),"4", IF(G17=(166745),"0", IF(G17=(""),""
)))))))

Now i want to add the result of this statement from consecutive rows.
i did sum on the results but i am not able to add the results of my
statements.

can you tell me how i can add the results of this statement?

And you don't need all the parentheses. And you should have something to say
what you want if none of the tests are true. If you're happy with 0 in this
case, use:

=IF(G17="","",IF(OR(G17=166718,G17=166719),1,IF(G1 7=16582,2,IF(G17=166685,4,0))))

Regards,
Fred

"Mike H" wrote in message
...
Try it like this

=IF(G17=(166719),1, IF(G17=(165852),2, IF(G17=(165851),0,
IF(G17=(166718),1, IF(G17=(166685),4, IF(G17=(166745),0, IF(G17=(""),""
)))))))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Xiamen" wrote:

I have created this "if" statement.
=IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0",
IF(G17=(166718),"1", IF(G17=(166685),"4", IF(G17=(166745),"0",
IF(G17=(""),""
)))))))

Now i want to add the result of this statement from consecutive rows.
i did sum on the results but i am not able to add the results of my
statements.

can you tell me how i can add the results of this statement?

On Mar 24, 5:40*pm, "Fred Smith" wrote:
And you don't need all the parentheses. And you should have something to say
what you want if none of the tests are true. If you're happy with 0 in this
case, use:

=IF(G17="","",IF(OR(G17=166718,G17=166719),1,IF(G1 7=16582,2,IF(G17=166685,4*,0))))

Regards,
Fred

"Mike H" wrote in message

...



Try it like this

=IF(G17=(166719),1, IF(G17=(165852),2, IF(G17=(165851),0,
IF(G17=(166718),1, IF(G17=(166685),4, IF(G17=(166745),0, IF(G17=(""),""
)))))))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"Xiamen" wrote:

I have created this "if" statement.
=IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0",
IF(G17=(166718),"1", IF(G17=(166685),"4", IF(G17=(166745),"0",
IF(G17=(""),""
)))))))

Now i want to add the result of this statement from consecutive rows.
i did sum on the results but i am not able to add the results of my
statements.

can you tell me how i can add the results of this statement?- Hide quoted text -

- Show quoted text -

I might consider controlling the cell with an Index/Match from a table.