| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formual
5,5,6,4,6,5,6,7,7,2
Group of data, I want to found court of A1:A10, 5 and <=7 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formual
=COUNTIF(A1:A10,"5")-COUNTIF(A1:A10,"7")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Winnie" wrote in message ... 5,5,6,4,6,5,6,7,7,2 Group of data, I want to found court of A1:A10, 5 and <=7 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the formual for calculating running pace? | Excel Worksheet Functions | |||
| Set Formual | Excel Discussion (Misc queries) | |||
| How to show file path in formual bar when linking workbooks? | Excel Discussion (Misc queries) | |||
| value inputs..another formual question | New Users to Excel | |||
| Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
Linear Mode
