| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using the countif function
Hi All
im using the countif function to add up all the cells in a range that contain the Letter D the formula works but the problem im having is that if there is on D in the range then the formula returns the 0 (zero) value how do i get it to just leave the cell blank ??? ps ive tries addin ,"") this does not work cheers guys or gals |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using the countif function
Just wrap the formula around in an If statement like
=If(Countif(yourrange,"D")=0,"",Countif(yourrange, "D")) "harrimanxix" wrote: Hi All im using the countif function to add up all the cells in a range that contain the Letter D the formula works but the problem im having is that if there is on D in the range then the formula returns the 0 (zero) value how do i get it to just leave the cell blank ??? ps ive tries addin ,"") this does not work cheers guys or gals |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using the countif function
One way:
=IF(COUNTIF(B1:B100,"D"),COUNTIF(B1:B100,"D"),"") -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "harrimanxix" wrote in message ... Hi All im using the countif function to add up all the cells in a range that contain the Letter D the formula works but the problem im having is that if there is on D in the range then the formula returns the 0 (zero) value how do i get it to just leave the cell blank ??? ps ive tries addin ,"") this does not work cheers guys or gals |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| countif OR function | Excel Worksheet Functions | |||
| CountIf function | Excel Worksheet Functions | |||
Linear Mode
