View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
markholt markholt is offline
external usenet poster
 
Posts: 13
Default SumIf - when I fill down the Range, Criteria & sum range changes

I would like to fill down & keep the same range & sum range - but let the
criterial advance by 1 - field in the next file. Is this possible?

Also, will excel keep the info (function) straight as I sort the file?

Thanks much