Verify my OFFSET formula is corrrect? 
Author Message
 Verify my OFFSET formula is corrrect?

Hello, Below you will see my original formula and my replacement formula
utilizing the OFFSET worksheet function.  I am looking for verificaton that
I did it properly. Yes it returns the proer value, but still unsure.

Currently my data resides in Sheet1C3:C27 & SCOCI!C3:C11
I want the formula to remain dynamic in case a row is inserted after
Sheet1!C27 or SCOCI!C11

=((COUNTIF(C3:C27,155))+(COUNTIF(SCOCI!C3:C11,155)))/SumPersonell

=((COUNTIF(OFFSET(C3,0,0,ROW(C30)-3,1),155))+(COUNTIF(OFFSET(SCOCI!C3,0,0,RO
W(C11)-3,1),155)))/SumPersonell



Mon, 31 Jan 2005 09:30:38 GMT  
 Verify my OFFSET formula is corrrect?
Disregard


Mon, 31 Jan 2005 13:03:14 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Giving back - Easy formula to verify values within a tolerance range

2. verifying the integrity of formulas

3. 2nd Posting - Verify Old Password before Verifying New One

4. Passing arguments to my offset formula

5. Offsetting ranges in a formula...

6. Offset Formula

7. Offset formula

8. Formula with Offsets

9. How can I avoid using tons of OFFSET in my formulae

10. Formula help needed (array, lookup, offset...)


 
Powered by phpBB® Forum Software © phpBB Group