Thread: counting cells that are 0 in a range of non-contiguous cells
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default counting cells that are 0 in a range of non-contiguous cells
Do you have a workaround for the 1000 character
limit in the name ListA?

I can never get more than 255 chars.

Use multiple area references:

=INDEX(FREQUENCY((rng1,rng2),{0}),2)

Biff

"Herbert Seidenberg" wrote in message
ups.com...
Harlan:
Thanks for pointing out my error.
Your solution works great.
Do you have a workaround for the 1000 character
limit in the name ListA?




Reply With QuoteReply With Quote