Thread: COUNT IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich Mogy Rich Mogy is offline
external usenet poster
 
Posts: 19
Default COUNT IF

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