Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Excel CountifS

### #1 manin Posted 15 December 2012 - 11:00 AM

manin

Member

• Member
• 70 posts
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

• 0

### #2 manin Posted 16 December 2012 - 05:33 AM

manin

Member

• Topic Starter
• Member
• 70 posts
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
```

• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users