| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Non Contiguous Cells Q
I want to create a formula that will Count the number of times cells
is a range are greater than 1. Ordinarly I would use the formula =COUNTIF(F$10:F$168,"0"), however my range is non-contiguous, it is however relative, in that the cells I wish to Count are always 3 apart. So if I was to avoid having to long type a formula with all the ranges I want to count, how would I do it? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non-contiguous cells | Excel Discussion (Misc queries) | |||
| Subtotal Non-contiguous cells | Excel Discussion (Misc queries) | |||
| counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
| How do I count non-contiguous cells? | Excel Worksheet Functions | |||
| Linking Non-Contiguous cells | Excel Discussion (Misc queries) | |||
Threaded Mode
