View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chicken Boy Chicken Boy is offline
external usenet poster
 
Posts: 1
Default Why does my sumif criteria appear as RC[-2] instead of B4 etc?

Hi,

All of a sudden, my formulas in Excel have gone wonky?

In 'sumif', the criteria is showing as RC[-2] and in vlookup, the
lookup-value is doing the same?

Regards
Chicken Boy