Thread: Indirect?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert[_4_] Robert[_4_] is offline
external usenet poster
  
Posts: 6
Default Indirect?
In message , Bob Phillips
writes
Isn't it just

=ROUNDDOWN(SUM(SUMIF([ABC.xls]Sheet1!$B$6:$B$69,{"EE3","EE6","HE3","HE6"
,"OE3","OE6","OHE3","OHE6"},([ABC.xls]Sheet1$E$6:$E$69)),-2)


With a tiny bit of tweaking it is! Many thanks
--
Robert
Reply With QuoteReply With Quote