Thread: sumproduct with indirect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
  
Posts: 125
Default sumproduct with indirect
Hi

With the help Pete UK of an earlier thread used the following formula

sumproduct(--(sheetname!A1:a20="GA01")--(sheetname!B1:b20=105))

What I now want to do is use the indirect function with sumproduct in a
summary sheet

sumproduct(--(""&c1&"!A1:a20,a6)--indirect(""&c1"!b1:b20=105

Cell A6 contains the first criteria (GA01)
Cell C1 contains the shhet name


Help would be appriciated as it is not working !

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200711/1

Reply With QuoteReply With Quote