Have you tried using Copy, Paste Special, Values when bringing in your data?

--
If this helps, please remember to click yes.


"mwdawg721" wrote:

I have a workbook with several sheets. One sheet serves as a 'dashboard' and
includes several SUMIF and COUNTIF formulas that reference cells on another
sheet. The other sheet contains information that is exported from a database
and pasted into the sheet on a regular basis. However, upon doing this, each
cell on the "dashboard" that contains a SUMIF or COUNTIF formula returns a
#REF! error message.

Is there a way to change this so that I can keep the SUMIF and COUNTIF
formulas and still be able to paste new info into the other sheet? Help
please!