Thread: can't use function 'countif' in named range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default can't use function 'countif' in named range
You can't use COUNTIF() in disjoint ranges. Use:

=COUNTIF()+COUNTIF()+...

instead
--
Gary''s Student - gsnu200811


"Roland" wrote:

have a named range from non-adjacent ranges
most of Excels build-in functions can be used with this named range (such
as, min, max are sum)
However the function CountIf can't be used,
got a message in the cell "#value!"
why is that ?
Reply With QuoteReply With Quote