Thread: Trying to sum cells across different worksheets in different locat
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
big john big john is offline
external usenet poster
  
Posts: 6
Default Trying to sum cells across different worksheets in different l
TM,

Here's what I ended up getting to work by putting my worksheet names in AA1
to AA21 on my summary worksheet.

=SUMPRODUCT(SUMIF(INDIRECT("'"&$AA$1:$AA$22&"'!$D$ 4:$D$100"),D4,INDIRECT("'"&$AA$1:$AA$22&"'!$B$4:$B $100")))

=SUMPRODUCT(SUMIF(INDIRECT("'"&$AA$1:$AA$22&"'!$D$ 4:$D$100"),D4,INDIRECT("'"&$AA$1:$AA$22&"'!$C$4:$C $100")))

Thanks for everyone's help!

John
Reply With QuoteReply With Quote