Is it possible to count number of appearances of a value in a table at different intervals?

[rufuxinix]

I have a table with numbers in 5 colums.
I want to know how many times a number appears in a colums in the last 10 rows, 20 rows, 30 rows, etc.
I can do it on one row with Countif but to replicate it to more rows is a very time consuming exercise.
Any easier ways of doing it in Excel?
Thanks.

 

[Special-K99]

Use ROW() to isolate rows,e g.
searching for a 1 in A1:E30 but only in the last 20 rows, ie the ROW() is greater than 10.

SUMPRODUCT((A1:E30=1)*(ROW(A1:E30)>10))

 

[rufuxinix]

Use ROW() to isolate rows,e g.
searching for a 1 in A1:E30 but only in the last 20 rows, ie the ROW() is greater than 10.

SUMPRODUCT((A1:E30=1)*(ROW(A1:E30)>10))

I don't see the Thank you reply I left here before, something wrong with this system as it keeps telling me I am not logged on, I have to keep relogging and it seems to drop
entries into the thread.
Anyway, thanks again the formula works well.

However I now face a new problem
I am working with a column
So my formula is
SUMPRODUCT((A1:A30=1)*(ROW(A1:AE30)>10))

I now want to copy the formula to the cell below to get the result for the number of times number 2 comes up in the same range.
Excel copies but changes the range to
SUMPRODUCT((A2:E31=1)*(ROW(A2:E31)>10))

How do i get around this issue?

Thanks in advance.

 

[rufuxinix]

Sorry, let me correct the previous post,

However I now face a new problem
I am working with a column
So my formula is
SUMPRODUCT((A1:A30=1)*(ROW(A1:A30)>10))

The new copied cell becomes
SUMPRODUCT((A2:A31=1)*(ROW(A2:A31)>10))

The range should have stayed as originally entered, in the previous cell

 

[Special-K99]

Oops forgot me $ signs

SUMPRODUCT((A$1:A$30=1)*(ROW(A$1:A$30)>10))

 

[rufuxinix]

Oops forgot me $ signs

SUMPRODUCT((A$1:A$30=1)*(ROW(A$1:A$30)>10))

Thank you very much, you're a star, problem solved!
Best regards.