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