I might be re-inventing the wheel here, but any assistance would be
appreciated.

I have a data import (SQL query) to one sheet of sales data (date, rep name,
amount, qty etc. etc. )
I am using a second sheet to extract certain info such as Sales in the week,
month, to date etc.
Trouble is, the data coming in does not multiply the QTY with the Sales unit
price, so I need an extra column
for total sales. I cannot put an extra column in the data sheet manually due
to the refresh moving the cell refences out of line
So how do I tell excel to add this column of data when I refresh the data ?

BTW, the formulas to extract the required data in the reporting sheet are
long enough and Im finding too difficult to add an extra qty * sales in them
for example...
=COUNT(IF((data!FU$2:FU$6382="MAREK")*(MONTH(data! M$2:M$6381)=$F$1)*(YEAR(data!M$2:M$6359)=$F$3),dat a!E$2:E$6381))
its just getting too mad!!

Thanks in advance
--
Vass