Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a table with Department, Practice and various amounts
For each department, practice combination I want to count the number of amounts between 500-1000, 1001-1500, 1501-2000, etc. I tried FREQUENCY, but found it fine when all I had to do was count for one departments, but now that I need department/practice combinations, it seems to be too cumbersome. Thanks in advance. Sample of data where column 1 is department, column 3 is practice and column 2 is amount 01 $3,000.00 17 01 $818.90 17 01 $1,098.20 17 01 $500.00 999 01 $500.00 999 01 $500.00 999 01 $540.00 999 01 $593.80 999 01 $628.52 999 01 $797.34 999 01 $797.34 999 01 $797.34 999 01 $1,157.35 999 01 $750.00 999 01 $1,343.25 999 01 $1,000.00 999 01 $3,355.80 999 01 $616.50 999 02 $540.00 4 02 $516.95 4 02 $538.89 4 02 $1,240.32 5 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |