| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
=countif(with two set of ranges; "0")
This is my formula =COUNTIF(E11:E18;"0") I also need to add in range
of E23:E50 I am not sure how to do it or is it possible to do. thanks in advance for your help |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
=countif(with two set of ranges; "0")
Hi,
Note i've changed ; to , for my version of Excel so change it back for yours:- =COUNTIF(E11:E18,"0")+COUNTIF(E23:E50,"0") Mike "Jontie" wrote: This is my formula =COUNTIF(E11:E18;"0") I also need to add in range of E23:E50 I am not sure how to do it or is it possible to do. thanks in advance for your help |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
=countif(with two set of ranges; "0")
On Dec 16, 4:36 am, Mike H wrote:
Hi, Note i've changed ; to , for my version of Excel so change it back for yours:- =COUNTIF(E11:E18,"0")+COUNTIF(E23:E50,"0") Mike "Jontie" wrote: This is my formula =COUNTIF(E11:E18;"0") I also need to add in range of E23:E50 I am not sure how to do it or is it possible to do. thanks in advance for your help- Hide quoted text - - Show quoted text - yea that bothers me alot as I am using opensource thanks for you help it worked for me happy holidays |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
