Why does my sumif criteria appear as RC[-2] instead of B4 etc?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
sounds like you managed to change your reference style

tools> Options> General - uncheck R1C1 reference style

Chicken said:
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
Click to expand...
 
sounds like you managed to change your reference style

tools> Options> General - uncheck R1C1 reference style

Chicken said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-calculate after a cell is filled in - Macro is looping!!! 2
Auto-calculate after a cell is filled in - macro shouldn't be loop 5
Why does the Formula in VBA not calculate 3
Why are the two codes below not getting the right formula for myworksheet event change formula? 2
Formula appearing instead of result 2
Excel How to get output of the formula instead of True or false 1
SUMIF with criteria "<>" & "=" 4
How to use Sumifs with vertically and horizontally criterias 3

Back
Top