View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Count if, excluding zeros

It is used to coerce TRUE/FALSE values to 1/0. The FREQUENCY(..)0 will
return an array of TRUE and FALSE values, the first - coerces this to an
array of -1/0, the second negates it to an array of 1/0, and SUM then just
adds them up.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
That works - thanks!!

By the way, what does the "--" before the frequency mean?

Thanks!