Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two columns in column b I have numbers that only 1-
4. in column c ihave numbers from 0-100. What i would like to do is compare column b with c. specifically I would like to count grades. match the number 4 and count in column c how many are greater than 90, and count when coulumn c is between 80 and 90, greater than 70 and less than 80, count for greater than 60 and less than 70. Heres what I would like to see: 90 80 70 60 1 2 3 TABLE SHOWS A COUNT OF GRADE SCORES THAT MATCH 4 1,2,3,4 I can do this in programming laguage with conditions and counters but I don't know how to do it excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting numbers | Excel Discussion (Misc queries) | |||
counting how many of the same numbers | Excel Discussion (Misc queries) | |||
Counting Numbers | Excel Discussion (Misc queries) | |||
counting numbers | Excel Discussion (Misc queries) | |||
Counting numbers | Excel Discussion (Misc queries) |