| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF on NonContiguous Cells?
Okay, so I think my issue with my COUNTIF is that the cells are not next to
each other. This is my range: (C3,E3,G3,I3,K3,M3). What I want to do is range all the cells in that range that have data equivalent to 1.00. What I am thinking is =COUNTIF(C3,E3,G3,I3,K3,M3, "=1"). But unfortunately that doesn't work. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average of 12 noncontiguous cells | Excel Discussion (Misc queries) | |||
| Adding noncontiguous cells | Excel Discussion (Misc queries) | |||
| Using Multiple, Noncontiguous Ranges in COUNTIF? | Excel Discussion (Misc queries) | |||
| noncontiguous cells | Excel Discussion (Misc queries) | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
Threaded Mode
