I need to get a formula for the following:

Search Column "C" for what is in "C4", if "C4" found in Column "C", search
Column "B" for "A6", if "A6" found in Column "B" get the sum from Column "A"

Sounds confusing I know

Please get back to me if you think you may be able to help.

Well, by definition whatever is in C4 is in column C, so perhaps that portion
of your question isn't stated correctly. Matter of fact, your entire
question is pretty ambiguous. Can you try to state it a little more clearly,
perhaps with an example?

"Deanna" wrote:

I need to get a formula for the following:

Search Column "C" for what is in "C4", if "C4" found in Column "C", search
Column "B" for "A6", if "A6" found in Column "B" get the sum from Column "A"

Sounds confusing I know

Please get back to me if you think you may be able to help.

"A" "B" "C"
1 4 MA
..58 1 BA+15
1 13 MA+30
1 7 MA
1 2 BA
1 1 BA+15
1 1 BA+15

This is what part of my sheet looks like. I need to put numbers in the
below chart with the information above


BA -1 BA BA+15
Associate I II
1 ? ?
1.5
2 ?
2.5 ?

The numbers to the far left refer to Column "A" above, and the "?" marks
need to be completed with the informaiton from all three. (So if Column "C"
is BA+15 and "B" states "Step 1" (indicated by the "1"), the the total from
Column "A" would be 2.58.

"Duke Carey" wrote:

Well, by definition whatever is in C4 is in column C, so perhaps that portion
of your question isn't stated correctly. Matter of fact, your entire
question is pretty ambiguous. Can you try to state it a little more clearly,
perhaps with an example?

"Deanna" wrote:

I need to get a formula for the following:

Search Column "C" for what is in "C4", if "C4" found in Column "C", search
Column "B" for "A6", if "A6" found in Column "B" get the sum from Column "A"

Sounds confusing I know

Please get back to me if you think you may be able to help.

I am not 1005 sure of your layout, but see if this helps. Assume your data
is in columns A, B and C as seems indicated and assume you have headers for
these columns so your data starts at A2, B2 and C2. Further assume your
Column "B" State criterion is located in F1 (for this example, that value is
1) and your Column "C" criterion is in F2 (that is, F1 contains, say,
BA+15). This formula will give you the sum you want...

=SUMPRODUCT((C1:C7=$F$2)*(B1:B7=$F$1)*(A1:A7))

Rick


"Deanna" wrote in message
...
"A" "B" "C"
1 4 MA
.58 1 BA+15
1 13 MA+30
1 7 MA
1 2 BA
1 1 BA+15
1 1 BA+15

This is what part of my sheet looks like. I need to put numbers in the
below chart with the information above


BA -1 BA BA+15
Associate I II
1 ? ?
1.5
2 ?
2.5 ?

The numbers to the far left refer to Column "A" above, and the "?" marks
need to be completed with the informaiton from all three. (So if Column
"C"
is BA+15 and "B" states "Step 1" (indicated by the "1"), the the total
from
Column "A" would be 2.58.

"Duke Carey" wrote:

Well, by definition whatever is in C4 is in column C, so perhaps that
portion
of your question isn't stated correctly. Matter of fact, your entire
question is pretty ambiguous. Can you try to state it a little more
clearly,
perhaps with an example?

"Deanna" wrote:

I need to get a formula for the following:

Search Column "C" for what is in "C4", if "C4" found in Column "C",
search
Column "B" for "A6", if "A6" found in Column "B" get the sum from
Column "A"

Sounds confusing I know

Please get back to me if you think you may be able to help.

BAsed on the data you provided, try this formula

=SUMPRODUCT(--(C1:C7="BA+15"),--(B1:B7=1),A1:A7)

If the BA+15 wil reside in a cell off to the side, say D1, and the #1 you're
testing for column B is in cell D2, you can use this formula

=SUMPRODUCT(--(C1:C7=D1),--(B1:B7=D2),A1:A7)



"Deanna" wrote:

"A" "B" "C"
1 4 MA
.58 1 BA+15
1 13 MA+30
1 7 MA
1 2 BA
1 1 BA+15
1 1 BA+15

This is what part of my sheet looks like. I need to put numbers in the
below chart with the information above


BA -1 BA BA+15
Associate I II
1 ? ?
1.5
2 ?
2.5 ?

The numbers to the far left refer to Column "A" above, and the "?" marks
need to be completed with the informaiton from all three. (So if Column "C"
is BA+15 and "B" states "Step 1" (indicated by the "1"), the the total from
Column "A" would be 2.58.

"Duke Carey" wrote:

Well, by definition whatever is in C4 is in column C, so perhaps that portion
of your question isn't stated correctly. Matter of fact, your entire
question is pretty ambiguous. Can you try to state it a little more clearly,
perhaps with an example?

"Deanna" wrote:

I need to get a formula for the following:

Search Column "C" for what is in "C4", if "C4" found in Column "C", search
Column "B" for "A6", if "A6" found in Column "B" get the sum from Column "A"

Sounds confusing I know

Please get back to me if you think you may be able to help.

I am not 1005 sure of your layout, but see if this helps. Assume your data
is in columns A, B and C as seems indicated and assume you have headers for
these columns so your data starts at A2, B2 and C2. Further assume your
Column "B" State criterion is located in F1 (for this example, that value
is 1) and your Column "C" criterion is in F2 (that is, F1 contains, say,
BA+15). This formula will give you the sum you want...

=SUMPRODUCT((C1:C7=$F$2)*(B1:B7=$F$1)*(A1:A7))

LOL... Sure, I said assume your data starts in the second row and what do I
do... I give you the formula for it starting in the first row.

=SUMPRODUCT((C2:C8=$F$2)*(B2:B8=$F$1)*(A2:A8))

By the way, the limiting to Row 8 in the formula is because that is all the
data you provided... change the 8 to the number of the maximum row you
expect to have data in.

Rick

Thank you so much. That's it.

"Rick Rothstein (MVP - VB)" wrote:

I am not 1005 sure of your layout, but see if this helps. Assume your data
is in columns A, B and C as seems indicated and assume you have headers for
these columns so your data starts at A2, B2 and C2. Further assume your
Column "B" State criterion is located in F1 (for this example, that value is
1) and your Column "C" criterion is in F2 (that is, F1 contains, say,
BA+15). This formula will give you the sum you want...

=SUMPRODUCT((C1:C7=$F$2)*(B1:B7=$F$1)*(A1:A7))

Rick


"Deanna" wrote in message
...
"A" "B" "C"
1 4 MA
.58 1 BA+15
1 13 MA+30
1 7 MA
1 2 BA
1 1 BA+15
1 1 BA+15

This is what part of my sheet looks like. I need to put numbers in the
below chart with the information above


BA -1 BA BA+15
Associate I II
1 ? ?
1.5
2 ?
2.5 ?

The numbers to the far left refer to Column "A" above, and the "?" marks
need to be completed with the informaiton from all three. (So if Column
"C"
is BA+15 and "B" states "Step 1" (indicated by the "1"), the the total
from
Column "A" would be 2.58.

"Duke Carey" wrote:

Well, by definition whatever is in C4 is in column C, so perhaps that
portion
of your question isn't stated correctly. Matter of fact, your entire
question is pretty ambiguous. Can you try to state it a little more
clearly,
perhaps with an example?

"Deanna" wrote:

I need to get a formula for the following:

Search Column "C" for what is in "C4", if "C4" found in Column "C",
search
Column "B" for "A6", if "A6" found in Column "B" get the sum from
Column "A"

Sounds confusing I know

Please get back to me if you think you may be able to help.