Thread: Dynamic Formulation with lots of sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excelenator Excelenator is offline
external usenet poster
  
Posts: 1
Default Dynamic Formulation with lots of sheets

You can use

=SUM(Sheet2:Sheet3!B3)

to sume the values of B3 on multiple sheets, however, the condition
part will not work across worksheets. You may need to perform the
conditional check on the individual worksheets by placing the formula

IF(A3=150,+b3,0) in a blank cell and then use the formula above to sum
all of the cells that contain that formula.


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=566624

Reply With QuoteReply With Quote