View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Help with cell function[_2_] Help with cell function[_2_] is offline
external usenet poster
 
Posts: 33
Default Copy exact formula

I need to copy this formula into 200 cells. =SUMPRODUCT(--('Consults
Tracking'!N5:N472="x"),--('Consults Tracking'!D5:D472="BU- Geropsych")) How
do I copy it to all the cells without it changing? Thanks