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 |