Kcope8302 wrote:
Thank you, That worked for me. I do have one more question. I am having an
issue with excel auto counting when i past an equation. When i past it, the
program automatically starts count up from the origin point. Is there a way
to state in an equation what is allowed to count up and what isnt.

Example:
=AVERAGEIFS(Data!P2:Data!P2957,Data!C2:Data!C2957, A2,Data!B2:Data!B2957,"Req")

The only point that I want to count is the A2. I would like the other
statements to remain as I had them. Is there a method of doing this without
having to past and then go back and alter each cell by itself?


Look at "About cell and range references" in the help file. Specifically, the
part about "The difference between relative and absolute references".