ing B C
D
1 Albany Ga 0034 Albany, Ga 3,445 3445
2 Albany Ga 0739 Tifton, Ga 2,488 1445
3 Total DMA 2,967 (avg of cells above)

I want to add a column "E" to the right that says if A3 has "DMA", then copy
formula in D3 over to E3, otherwise "". Does this make sense? Also, I'm
averaging many different numbers of rows at a time, so I just can't copy the
average formula down. can someone help?

Looks like part of your post got cut off, but answering based on what I can
see here, I'd say this is really simple -- so simple that maybe I've
misunderstood the question. Try this:

=IF(A3="DMA",D3,"")

This IF function displays the contents (the value, not the formula) of D3 if
A3's contents (the value again) is "DMA"; otherwise it displays "". If that
isn't exactly what you wanted, then maybe the part of your post that vanished
has some relevant information.

--- "Neese" wrote:
ing B C
D
1 Albany Ga 0034 Albany, Ga 3,445 3445
2 Albany Ga 0739 Tifton, Ga 2,488 1445
3 Total DMA 2,967 (avg of cells above)

I want to add a column "E" to the right that says if A3 has "DMA", then copy
formula in D3 over to E3, otherwise "". Does this make sense? Also, I'm
averaging many different numbers of rows at a time, so I just can't copy the
average formula down. can someone help?