Thread: Why does my sumif criteria appear as RC[-2] instead of B4 etc?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
blackbox via OfficeKB.com blackbox via OfficeKB.com is offline
external usenet poster
  
Posts: 59
Default Why does my sumif criteria appear as RC[-2] instead of B4 etc?
sounds like you managed to change your reference style

tools Options General - uncheck R1C1 reference style

Chicken Boy wrote:
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

--
Message posted via http://www.officekb.com

Reply With QuoteReply With Quote