formula drag down when using filter in 2007

C

CAM

When I use the filter function, sometimes the formula works on visible cells
only and sometimes it fills in the cells which were filtered out. How do I
only write formula to cells I want? This didn't happen with 2003 version
excel
 
Top