Dynamic Range

Thank you in advance for your help.

I am trying to write a formula that returns a counter but the range where it is counting is dynamic.

For a static range, I use the formula =CountIf(A:A,100) which returns all "100" in column A.

For the range, I want to reference two cells which value can change.

So instead of the range being the whole A column, it will only be a part of the A column.

I tried the following but without success: =COUNTIF(K(G55):K(G54),100)

where G55 = 10, G54 = 15

which would make the formula: =countif(K10:k15,100)

Any help is appreciated.

Simon

=countif(index(a:a,g55):index(a:a,g54),100)

Thank you all for the very fast replies, I tried Sambo Kid and it worked like a charm.

Thank you!!