| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with non-continuous range
Can I use the COUNTIF function on an area that does not have a continuous
range? Example: =COUNTIF(AG4:AG25,AA4:AA26,U4:U26,B4:B26,H4:H26,N4 :N26,AZ4:AZ25,AT4:AT25,AN4:AN25,1) Generates an error - too many arguments. I have also tried it with quotes: =COUNTIF("AG4:AG25,AA4:AA26,U4:U26,B4:B26,H4:H26,N 4:N26,AZ4:AZ25,AT4:AT25,AN4:AN25",1) But this, too, generates a general error. Suggestions? I have a complex spreadsheet and I need to count values all over it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named range not continuous. How to display values? | Excel Worksheet Functions | |||
| maximum over a non continuous range | Excel Worksheet Functions | |||
| SUMIF Non-Continuous Range | Excel Worksheet Functions | |||
| COUNTIF With Non-Continuous Cells | Excel Worksheet Functions | |||
| Sum function for non-continuous range | Excel Worksheet Functions | |||
Threaded Mode
