[manin]

Hello, I have an excel file with 2000 rows.
In each row I want to calculate how many numbers are till, 10, between 10 and 20 etc up to 49.
I use countifs, in the first 2 rows.
I want to manage with the first row, calculate the other 2000 rows.
How is this done?
I tried to drag from the first to the down rows, but it did not work

Attached Thumbnails

• 

[Advertisements]

I am trying to build a macro to do my job...

For start I wrote a code for numbers <10. I want to count how many numbers <10 are in each row,
and put it, in H column...
I am doing something wrong...Can anybody help?
Thanks

Sub Zone()
       Dim rw As Integer
       rw = 2
       For rw = 2 To 10
        Worksheets("Sheet1").Range("H & rw") = "=Countif(B & rw:G rw,<10)"
        rw = rw + 1
        Next rw
End Sub

[manin]

I am trying to build a macro to do my job...

For start I wrote a code for numbers <10. I want to count how many numbers <10 are in each row,
and put it, in H column...
I am doing something wrong...Can anybody help?
Thanks

Sub Zone()
       Dim rw As Integer
       rw = 2
       For rw = 2 To 10
        Worksheets("Sheet1").Range("H & rw") = "=Countif(B & rw:G rw,<10)"
        rw = rw + 1
        Next rw
End Sub