Help with Conditonal Sum

[Glen Mettler]

I used the Conditonal Sum Wizard to sum values based on 2 different
criteria. Here is what I got:
{=SUM(IF('BOE List'!$D$2:$D$34=411110,IF('BOE List'!$P$2:$P$34="MDR",'BOE
List'!$I$2:$I$34,0),0))}

When I filldown the formula, I get the same answer for everything because
=411110 and "MDR" are hard coded.
When I go into the other cells and change either of those (411110 to 411120
or "MDR" to "PSR") I get no data - the cell is blank.

I noticted that when I go ito the formula bar the {} brackets go away. Even
if I put them back, I get no data.

The data I need to sum is on sheet "BOE List" with the result going to
"Bogie" sheet
I need the conditions to be dynamic - 411110 is a WBS number and resides in
column A8 thru A12 (Bogie sheet)
"MDR" is and Event and resides in J5 (on Bogie sheet).

How can I do this?

Glen

 

[Bob Phillips]

Try this

=SUMPRODUCT(--('BOE List'!$D$2:$D$34=A8),--('BOE List'!$P$2:$P$34=J5),'BOE
List'!$I$2:$I$34)


and add more for the other criteria

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Glen Mettler]

Thanks Bob - Just what I needed.

Glen

Try this

=SUMPRODUCT(--('BOE List'!$D$2:$D$34=A8),--('BOE List'!$P$2:$P$34=J5),'BOE
List'!$I$2:$I$34)


and add more for the other criteria

--

HTH

RP
(remove nothere from the email address if mailing direct)