| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count nonblank cells with conditions
I used check marks in a spreadsheet. Some of the cells have a pattern
(yellow) to as an identifier. I need to be able to count the number of cells that have the yellow pattern. I used the formula =COUNTA(RANGE) which adds all the nonblank cells in the column, but now I need to isolate the cells in the specific row that have the yellow pattern. Please advise. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count nonblank cells based on another column | Excel Worksheet Functions | |||
| How do I count nonblank text cells in Excel | Excel Discussion (Misc queries) | |||
| count 2 nonblank cells on multiple worksheets | Excel Discussion (Misc queries) | |||
| How do I count nonblank cells in rows within Excel? | New Users to Excel | |||
| Count nonblank cells with multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
