View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mmatz mmatz is offline
external usenet poster
 
Posts: 4
Default what does this forumla mean?

I got this forumla:
=SUM(IF(('[Title and Reg Chat Data.xls]FY08'!$C$2:$C$9000=W$66)*('[Title and
Reg Chat Data.xls]FY08'!$E$2:$E$9000=$C67),'[Title and Reg Chat
Data.xls]FY08'!$A$2:$A$9000,0))

I understand it is going to the worksheet title and reg, to worksheet fy08,
looking at the range c2:c9000- what is the = w66? As well as the = c67? I
know it is an if asking if those ranges = those cells, but what is the true
part? and how does sum fit in?

Thanks!!!