Quote:
Originally Posted by thebridge15
wait shit, roger can correct me but I don't think you can use a dual conditional (like 4<X<10) in a countif
|
You can but he'd have way too many iterations to get up to 4,456. It takes 149 intervals to get to 4,456 in groups of 30.
Quote:
Originally Posted by swordo84
4456 .
|
You're going to need to use a pivot table. It's really not difficult.
I'm going to assume your data is set up in a traditional spreadsheet format.
Select cell A1 in that worksheet.
Go to Insert and then click on pivot table (It's just under and to the left of the Insert tab of the ribbon)
A new little screen will appear - just click on okay
That will create a new worksheet (don't worry, nothing happens to the old worksheet. it's still fine)
You will see a menu on the right that says Pivot Table Fields
Select the column with your number and drag it down to the box where it says "rows"
Select the column again and drag it to where it says "values"
You will see the pivot table start to the build on your left.
There should be two columns in your pivot table...
Row Labels & Sum of (Whatever is the name of your column)
Right click on the Row Labels column and select "Group" and enter
Starting at 1
Ending at 5000
By 30
Right Click on "Sum of (Whatever is the name of your column)"
Summarize values by - Count
You're done.