Thread: sumproduct with indirect
View Single Post
  #5   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
thanks Kostis for the speedy response,

worked a treat

regards

vezerid wrote:
Simply replace ="GA01" with A6. It is not part of the INDIRECT.

=SUMPRODUCT((INDIRECT("'"&C1&"'!A1:A20")=A6)*(IND IRECT("'"&C1&"'!
B1:B20")=A7))

Regards
Kostis

thanks Kostis

[quoted text clipped - 20 lines]
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200711/1

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

Reply With QuoteReply With Quote