Thread: Updating a Formula Based on Multiple sheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pecoflyer[_296_] Pecoflyer[_296_] is offline
external usenet poster
  
Posts: 1
Default Updating a Formula Based on Multiple sheets

Would this help ?


Code:
--------------------
=SUMIF(INDIRECT("'"&B$4&"'!E5:E9");"free";(INDIREC T("'"&B$4&"'!D5:D10")))
--------------------


( replace ; with , if needed)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93158

Reply With QuoteReply With Quote