using numbers from cells in formula

[SQUIDD]

HI

Ok, so lets say i use
=COUNTA('MY SELECTIONS'!A1:A100)-1
no problem

but lets say the 1 was in cell z1 and the 100 was in cell z2.

can it be done and if so how, im goint to kick myself its easy.

thanks for looking

Dave

 

[shg]

=counta(index(a:a, z1):index(a:a, z2))

 

[SQUIDD]

oh ok, thanks shg.

thankyou very much.

it was not the answer I was expectiong but it certianly does work.

i also have this formula, could the same be applied to countifs?

=COUNTIFS('MY SELECTIONS'!F:F,1)

thanks again

dave

 

[SQUIDD]

ok shg

think i sussed out how it all works now thanks

=COUNTIFS(INDEX('MY SELECTIONS'!F:F, H27):INDEX('MY SELECTIONS'!A:A, H28),1)

cheers

great job

dave

 

[shg]

You're welcome.