| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cells with a criteria
Hi
Please can anyone help. I need to count a group of cells that are spread through the spreadsheet which meet a criteria range e.g count the number of cells for X2, BX2, CX2 that are greater than or equal to 40 but less than or equal to 49. I cant seem to use COUNTIF. Presumably because it needs a range e.g. X2:CX2 and I do not not want to count all cells in the range, just specific cells. Many thaks for any help. Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Counting cells using multiple criteria | Excel Worksheet Functions | |||
| Counting blank cells until value is reached | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Threaded Mode
