Hi all,

Stumped on this one. I have a named range "metrics" which evaluates to the values {3367,1066,789,496,496,379,371}. (The named range definition is a formula using the LARGE function to sort the results of an OFFSET lookup.)

I want to count the number of times a particular value appears in the array of values, so I expect this to work:

=COUNTIF(metrics,496)

This returns a #VALUE error. Using Excel's Evaluate Formula tool, I see the named range expand out to the array of values just fine, then the COUNTIF function throws the error. Everything I've seen around the net indicates COUNTIF should work with a named range.

There's no problem with the named range and it refers to numbers (ex. =SUM(metrics) evaluates no problem). I'm happy to post a sample workbook if it'd be helpful.

Any idea what's going on here? I'd appreciate any insight!

Thanks,
Keith