Thank you Mike but I am an idiot

So it says IF(('[Title and Reg Chat Data.xls]FY08'!$C$2:$C$9000=W$66
meaning it is adding the range c2:c9000? and let it know if they = W66

Then multiply that with )*('[Title and
Reg Chat Data.xls]FY08'!$E$2:$E$9000=$C67) and let it know if they = c67

Then if true [Title and Reg Chat
Data.xls]FY08'!$A$2:$A$9000

Otherwise return 0

What is the sum?

"Mike H" wrote:

Hi,

In the FY08 sheet it is trying to match a value in W66 in the C column range
and the value in C67 in the E column range and if a match is found it's
summing the corresponding value in the A column Range.

Mike

"mmatz" wrote:

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!!!