View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EricSHEM EricSHEM is offline
external usenet poster
 
Posts: 2
Default sum across 12 worksheets

I have a spreadsheet with 12 worksheets, one for each month. I would like to
be able to use a 13th worksheet to add amounts from all 12 pertaining to a
date range specified on each sheet. I've tried sumif but the formula would
be VERY long and complex.

Thanks!