Keeping the cell reference for SUMIF when deleting the data it references

Hi All,

I have a table (let's call it report) that I populate using the SUMIF function. Basically it looks for data of a certain type and sums it. The data is on another worksheet in the same workbook.

What happens is that every month I will copy the report table to another worksheet for historical reference. I then delete the 'data' table. What happens is that I will get #REF! errors on all my SUMIF functions. I have to go through the pain of resetting all of them.

An example of one of the codes I use is

Please Login or Register  to view this content.

How do I keep the function from getting these errors and having to fix them each time?

Thanks all.

Tried it and it works. Thanks!

Rep added :D