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