| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writing formula using COUNTIF
Try this:
=COUNTIF(A1:J1,"=1")-COUNTIF(A1:J1,"6") Another unusual way: =INDEX(FREQUENCY(A1:J1,{0,6}),2) -- Biff Microsoft Excel MVP "Suz" wrote in message ... a have a row of answers giving a rating from 0-10. I need to count the number of people who scored the question between 1-6. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help in writing a formula | Excel Discussion (Misc queries) | |||
| Help writing a formula | Excel Worksheet Functions | |||
| Writing a Formula | About this forum | |||
| Writing a formula | Excel Worksheet Functions | |||
| I need help writing a formula. | Excel Worksheet Functions | |||
Hybrid Mode
