Range Reference after Deleting Rows 1

[mveera]

Hi,

I am displaying the sum of two columns (in sheet2) , in two cells in sheet1. the values in sheet2 will deleted and loaded based on some criteria selected by the user.
so cell1 will be sum(a1:a65536) and cell2 sum(b1:b65536).

when i delete all the rows in sheet2 i get #REF! error in the cells. Instead deleting if i do a clear it works fine. what should be the formula for the cells so that even if i delete the rows it displays 0 and not an error.

Is it possible to do with formulas r should i write a macro for each cell.

Thanks
Veera

 

[RobBroekhuis]

You need your cell formulas to be:

=SUM(Sheet2!A:A)
etc.

Rob

 

[mveera]

Thanks Rob, it worked.