how to read R1C1 formula

		Microsoft Office Forums > Microsoft Excel > Excel
how to read R1C1 formula

FAQ

Thread Tools

Display Modes

10-03-2010, 10:00 AM

Suhanti

Windows Vista how to read R1C1 formula

Office 2007

Novice

Join Date: Oct 2010

Posts: 2

how to read R1C1 formula

Hello everyone
I am new to Excel and I am wondering if you can help me understand R1C1 formulas
this is the A1 formula:

SUMIF($F$10:$F$31,31,$G$10:$G$31)

This is the R1C1 formula...

SUMIF(R[6]C6:R[27]C6,31,R[6]C7:R[27]C7)
I don't know why it's referencing R[27] when F10 to F31 is 22 rows only.

Cheers
Su

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Documents are Read-only	oldbeard	Office	0	09-27-2010 07:45 PM
Read Only problem	gg80	Excel	2	08-05-2010 09:09 AM
Need Help With SUMIF Formula In R1C1 Style	Todd	Excel	9	02-27-2010 08:30 PM
Need Help Re: Read-Only	mbarbaro	Excel	1	07-13-2009 09:16 AM
Read Receipt	lfreng	Outlook	0	04-11-2006 10:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:23 PM.