If statement
 

I have been reading many threads regarding formulas what I am attempting to
do is create a formula that will take the range of A6:A19 and if there is a
V, D, or M in that cell then pick up the number in column F6:F19 on the same
row.

Example A7 has V, A10 has D, and A18 has M so I need it to pick of the value
of F7+F10+F18 for a sum.

Is there a faster way than an IF statement for each row?

If statement
 

You have answers in your other post

http://www.microsoft.com/office/comm...0-e1f9075d5118
--
Mike

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


"Debra Reid" wrote:

I have been reading many threads regarding formulas what I am attempting to
do is create a formula that will take the range of A6:A19 and if there is a
V, D, or M in that cell then pick up the number in column F6:F19 on the same
row.

Example A7 has V, A10 has D, and A18 has M so I need it to pick of the value
of F7+F10+F18 for a sum.

Is there a faster way than an IF statement for each row?

If statement
 

=IF(A7="v",F7,IF(A7="d",F7,IF(A7="m",F7,"")))
Russell Dawson
Excel Student


"Debra Reid" wrote:

I have been reading many threads regarding formulas what I am attempting to
do is create a formula that will take the range of A6:A19 and if there is a
V, D, or M in that cell then pick up the number in column F6:F19 on the same
row.

Example A7 has V, A10 has D, and A18 has M so I need it to pick of the value
of F7+F10+F18 for a sum.

Is there a faster way than an IF statement for each row?

If statement
 

Hmmm...

This post is a lot different from your other post.

Try this...

=SUM(SUMIF(A6:A19,{"V","D","M"},F6:F19))

--
Biff
Microsoft Excel MVP


"Debra Reid" wrote in message
...
I have been reading many threads regarding formulas what I am attempting to
do is create a formula that will take the range of A6:A19 and if there is
a
V, D, or M in that cell then pick up the number in column F6:F19 on the
same
row.

Example A7 has V, A10 has D, and A18 has M so I need it to pick of the
value
of F7+F10+F18 for a sum.

Is there a faster way than an IF statement for each row?