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