View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bgkgmg bgkgmg is offline
external usenet poster
 
Posts: 40
Default Move to next line

I am using the SUMIF formula in sh1 B34 that refers to info in sh2 colC&D. I
want the next cell in sh1, B35, to copy the next cell in sh2 colD that
formula returns. I do not know where the first value in colD will fall so
the formula keeps adding the values in the first cell.
Thanks