| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif, blank if zero
Hi,
When countif does not find any occurrences, it writes "0". Is there anyway to change that so that it writes nothing - leaves a blank)? -- eugene |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif, blank if zero
=IF(COUNTIF([whatever])0, COUNTIF([whatever]), "") should do the trick;
don't know if there's a more elegant way than that. "eugene" wrote: Hi, When countif does not find any occurrences, it writes "0". Is there anyway to change that so that it writes nothing - leaves a blank)? -- eugene |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif, blank if zero
that was quick. thanks
-- eugene "Fay Roberts" wrote: =IF(COUNTIF([whatever])0, COUNTIF([whatever]), "") should do the trick; don't know if there's a more elegant way than that. "eugene" wrote: Hi, When countif does not find any occurrences, it writes "0". Is there anyway to change that so that it writes nothing - leaves a blank)? -- eugene |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif, blank if zero
You're welcome! I was about to post my own query and thought "Oooh, I know
the answer to *that* one...!" F "eugene" wrote: that was quick. thanks -- eugene "Fay Roberts" wrote: =IF(COUNTIF([whatever])0, COUNTIF([whatever]), "") should do the trick; don't know if there's a more elegant way than that. "eugene" wrote: Hi, When countif does not find any occurrences, it writes "0". Is there anyway to change that so that it writes nothing - leaves a blank)? -- eugene |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use multiple criteria with COUNTIF: between dates and not blank | Excel Worksheet Functions | |||
| COUNTIF & Blank Cells | Excel Discussion (Misc queries) | |||
| COUNTIF, dates and blank cell criteria | Excel Discussion (Misc queries) | |||
| How to COUNTIF blank cells? | Excel Worksheet Functions | |||
| Countif not blank | Excel Worksheet Functions | |||
Hybrid Mode
