|
|
#1
10-03-2010, 10:00 AM
|
|||
|
|||
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 
|
|
|
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 |
Windows Vista 
Office 2007
Threaded Mode