View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
#REF error #REF error is offline
external usenet poster
 
Posts: 1
Default How to find the formula inside #REF error

Hi ,
I have a formula which is refering to a another sheet as follows

=SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!)

I want to know what is the formula written inside the #REF!

Is there any way I can find the formula inside the #REF

Thanks
MKJ