| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Barry or Dave
Thanks for helping me with =COUNTIF($AT3810:$FI3810,"D") yesterday
Another question. Do you know of a way for it to return a blank instead of a zero if no "D's" exits? Thanks, Doug |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Barry or Dave
=if(COUNTIF($AT3810:$FI3810,"D")=0,"",COUNTIF($AT3 810:$FI3810,"D"))
On Oct 20, 7:34*pm, "Doug Mc" wrote: Thanks for helping me with =COUNTIF($AT3810:$FI3810,"D") yesterday Another question. Do you know of a way for it to return a blank instead of a zero if no "D's" exits? Thanks, Doug |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Barry or Dave
Thanks,
I think this worked ok. I need to do some more testing to be sure. Doug =if(COUNTIF($AT3810:$FI3810,"D")=0,"",COUNTIF($AT3 810:$FI3810,"D")) On Oct 20, 7:34 pm, "Doug Mc" wrote: Thanks for helping me with =COUNTIF($AT3810:$FI3810,"D") yesterday Another question. Do you know of a way for it to return a blank instead of a zero if no "D's" exits? Thanks, Doug |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Barry or Dave
You could consider just switching off zeros display in the sheet altogether
via clicking Tools Options View tab. Uncheck "Zero values" OK -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dave phlogiston appears in spreadsheet cell when I type Dave P | Excel Discussion (Misc queries) | |||
| Dave Peterson...Oh no, not her again... | Excel Discussion (Misc queries) | |||
| Dave Peterson...HELP!!!! | Excel Discussion (Misc queries) | |||
| Dave Peterson | Excel Worksheet Functions | |||
| Dave Peterson | Excel Discussion (Misc queries) | |||
Linear Mode
