can't use function 'countif' in named range
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 ?
|