| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem (maybe simple) displaying certain text
Hi all,
This maybe a simple fix, but I cannot seem to get it. I have a range, let's say A3:A30, each containing a 1 or 0. I would like to have a cell show how many 1's and how many 0's in the following format: (x-y) where x =1's and y = 0's. Any ideas? I tried using =COUNTIF(A3:A30,"1") in a cell and =COUNTIF(A3:A30,"0") in another, then displaying those numbers in a cell, but that didn't work either. Any ideas? Thanks, Rick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
problem (maybe simple) displaying certain text
how about this in the cell
="(" & COUNTIF(A3:A30,"1")&"- "&COUNTIF(A3:A30,"0")&")" -- Gary "Squalle" wrote in message ... Hi all, This maybe a simple fix, but I cannot seem to get it. I have a range, let's say A3:A30, each containing a 1 or 0. I would like to have a cell show how many 1's and how many 0's in the following format: (x-y) where x =1's and y = 0's. Any ideas? I tried using =COUNTIF(A3:A30,"1") in a cell and =COUNTIF(A3:A30,"0") in another, then displaying those numbers in a cell, but that didn't work either. Any ideas? Thanks, Rick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
problem (maybe simple) displaying certain text
Basically should work.
I just tried =COUNTIF(A3:A30,1)-COUNTIF(A3:A30,0) No problems. Cheers, Joerg "Squalle" wrote in message ... Hi all, This maybe a simple fix, but I cannot seem to get it. I have a range, let's say A3:A30, each containing a 1 or 0. I would like to have a cell show how many 1's and how many 0's in the following format: (x-y) where x =1's and y = 0's. Any ideas? I tried using =COUNTIF(A3:A30,"1") in a cell and =COUNTIF(A3:A30,"0") in another, then displaying those numbers in a cell, but that didn't work either. Any ideas? Thanks, Rick |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
problem (maybe simple) displaying certain text
Your formula is set to count if the string 0 or string 1 is in the cell
range Try using =COUNTIF(A3:A30,1) and =COUNTIF(A3:A30,0) Then subtract one from the other e.g. =COUNTIF(A3:A30,1) - COUNTIF(A3:A30,0) -- Cheers Nigel "Squalle" wrote in message ... Hi all, This maybe a simple fix, but I cannot seem to get it. I have a range, let's say A3:A30, each containing a 1 or 0. I would like to have a cell show how many 1's and how many 0's in the following format: (x-y) where x =1's and y = 0's. Any ideas? I tried using =COUNTIF(A3:A30,"1") in a cell and =COUNTIF(A3:A30,"0") in another, then displaying those numbers in a cell, but that didn't work either. Any ideas? Thanks, Rick |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
problem (maybe simple) displaying certain text
Thanks All,
Gary got it. It was the "&" that I was missing. I, for some reason, was trying to use "+". Too much PERL programming lately... Thanks Gary! Rick "GKeramidas" wrote in message ... how about this in the cell ="(" & COUNTIF(A3:A30,"1")&"- "&COUNTIF(A3:A30,"0")&")" -- Gary "Squalle" wrote in message ... Hi all, This maybe a simple fix, but I cannot seem to get it. I have a range, let's say A3:A30, each containing a 1 or 0. I would like to have a cell show how many 1's and how many 0's in the following format: (x-y) where x =1's and y = 0's. Any ideas? I tried using =COUNTIF(A3:A30,"1") in a cell and =COUNTIF(A3:A30,"0") in another, then displaying those numbers in a cell, but that didn't work either. Any ideas? Thanks, Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sounds simple but isn't - displaying cell text | Excel Worksheet Functions | |||
| Problem displaying color | Excel Discussion (Misc queries) | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Simple Find Text problem | Excel Programming | |||
| Problem in displaying the chart | Charts and Charting in Excel | |||
Linear Mode
