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

Disregard