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

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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1

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