Not the least bit clearer. The formulas given you EXACTLY met your first
statement of the problem. Now you say that's not really the problem and
offer this new tidbit below. However, this extra info just seems to cloud
things up for me.

Let's try again with a clear, concise statement of the issue, please


"Connie Martin" wrote:

In both of these formulas, what they are giving is the exact same value in
N3, N6 and N9. N3, N6 and N9 are formulas of =SUM which need to calculate
the cells to the left of N54, which should return a different value based on
what's in the cells to the left. Hope that is a little clearer!

Connie

"Connie Martin" wrote:

Cells N3, N6 and N9 contain an =SUM formula.
In N54, for example, I need a formula that will pull the formula from N3 if
PL is entered in C54, or from N6 if ST is entered in C54, or from N9 if PR is
entered in C54.

Connie