View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default logic that returns a count

I think you will get #VALUE if you do not commit the formula with
CTRL-SHIFT-ENTER or if you have errors in the columns. It should work
with spaces in either B or D because these will return FALSE, and so 0
will be added to the cumulative sum - why not try it?

Pete