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

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

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

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
---