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.