| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculating 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 with conditions | Excel Worksheet Functions | |||
| Adding only NONBLANK cells | Excel Discussion (Misc queries) | |||
| tally of nonblank cells | Excel Worksheet Functions | |||
| Count NonBlank Cells | Excel Programming | |||
| Adding NonBlank Cells | Excel Worksheet Functions | |||
Threaded Mode
