Thread
:
help with countif function
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
help with countif function
Look in the vba help index for FINDNEXT. A good example.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Gareth Wretham" wrote in message
ups.com...
hi - I want to report a fixed value of '1' if the term 'defect raised'
appears in a range of cells, regardless of frequency.
the current formula I have is =COUNTIF(D49:M52,"defect raised")
but this reports the frequency instead of the value 1.
ie this should be a binary value - 1 if the term is present and 0 if
not.
no idea how to do this, any help appreciated.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett