| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In creating a COUNTIF and a COUNT to show as ie 4of10?
I'm realative new user of excel. And I'm tring to set up a file to
automatically countif and count. I understand how to do one individually, but how can I get them to show as: 4 of 10 all in one cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In creating a COUNTIF and a COUNT to show as ie 4of10?
Assuming the 4 is the result of the COUNTIF and 10 is the result of the
COUNT... =COUNTIF(...)&" of "&COUNT(...) -- Biff Microsoft Excel MVP "tobin.palmer" wrote in message ... I'm realative new user of excel. And I'm tring to set up a file to automatically countif and count. I understand how to do one individually, but how can I get them to show as: 4 of 10 all in one cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In creating a COUNTIF and a COUNT to show as ie 4of10?
On Sun, 21 Feb 2010 09:28:01 -0800, tobin.palmer
wrote: I'm realative new user of excel. And I'm tring to set up a file to automatically countif and count. I understand how to do one individually, but how can I get them to show as: 4 of 10 all in one cell? Try this formula: =COUNTIF(...) & " of " & COUNT(...) Hope this helps / Lars-Åke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using COUNTIF for multiple text data creating a logic statment | Excel Worksheet Functions | |||
| Creating a formula to show year to date total. | Excel Discussion (Misc queries) | |||
| Creating a nested COUNTIF???? | Excel Worksheet Functions | |||
| having trouble creating chart to show monthly totals | Charts and Charting in Excel | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
Linear Mode
