View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default Dynamic subtotals and eliminate dupes

In article ,
ttbbgg wrote:

OK, no more error, but I am getting a count of 0. Help!


Make sure that you confirm the formula with CONTROL+SHIFT+ENTER, instead
of just ENTER. In other words, type the formula, press the CONTROL and
SHIFT keys down, while these two keys are pressed down, press ENTER.
Excel will place braces {} around the formula, indicating that you've
entered the formula correctly.

Hope this helps!