Not really, because you are mixing up rows and columns - you can't
have a row E ! It might be better to give a small example of what you
have and relate it to the exact columns and rows that you are using,
so any solutions proposed should work for you without having to make
massive changes to the formula to suit your exact layout.

It seems as if column B can contain both text and numeric values - so
what do you want to happen in cell C22 with the text values in column
B that equal the text value in G2? Do you want to multiply the
corresponding values from column E?

Pete

On Nov 21, 7:29 pm, Jeanne wrote:
Sorry - Okay, I have a column, in one row is text data, in another row is
numerical data. I want a formula that says, if text in B3 =g2, then
duplicate numerical data in E3 into cell C22 for a multiplication formula.
SO, I want all the numerical data in row E that is from a g2 originator to
be multiplied in yet another cell.

Does that help?

Jeanne



"Pete_UK" wrote:
If G1 contains a text value, how can you multiply it together? What do
you mean by "pull text out of one row"? Please re-phrase.

Pete

On Nov 21, 6:58 pm, Jeanne wrote:
I am looking for an if then formula that will pull text out of one row, and
if that text equals, say, G1, then to multiply all G1's together.

Any ideas?

Jeanne- Hide quoted text -

- Show quoted text -