| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting by a Range of Values?
Is there any easy way to make this forumula Repeat?
I want to do 0-100, 101-200 etc.. But if I try to just drag and copy the forumla It insists on going A1:A50 and then A2:A51, A3:52 etc... Maybe something like the following csv file would meet your need. Fill in the formula in B2 and copy it down. _________________________________________________ 64,"=COUNTIF(A:A,""<101"")" 876,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 345,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 975,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 366,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 436,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 248,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 235,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 532,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 4546,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 5653,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 444,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 5544,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 554,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 975,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 433,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 643,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 532,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 33432,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 335,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 3221,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 453,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 222,"=COUNTIF(A:A,""<=""&ROW()*100)-COUNTIF(A:A,""<""&(ROW()-1)*100+1)" 322, 542, 712, 7532, 673, 742 532 2342 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| MIN with zero values in the range | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
