help on conditional

[Guest]

Here is what I have,

=SUM(IF(Sheet1!D9="JF",Sheet1!E9,0)+IF(Sheet1!D10="JF",Sheet1!E10,0)+IF(Sheet1!D11="JF",Sheet1!E11,0)+IF(Sheet1!D12="JF",Sheet1!E12,0)+IF(Sheet1!D13="JF",Sheet1!E13,0)+IF(Sheet1!D14="JF",Sheet1!E14,0)+IF(Sheet1!D15="JF",Sheet1!E15,0)+IF(Sheet1!D16="JF",Sheet1!E16,0)*IF(Sheet1!D17="JF",Sheet1!E17,0)+IF(Sheet1!D18="JF",Sheet1!E18,0)+IF(Sheet1!D19="JF",Sheet1!E19,0)+IF(Sheet1!D20="JF",Sheet1!E20,0)+IF(Sheet1!D21="JF",Sheet1!E21,0)+IF(Sheet1!D22="JF",Sheet1!E22,0)+IF(Sheet1!D23="JF",Sheet1!E23,0)+IF(Sheet1!D24="JF",Sheet1!E24,0)+IF(Sheet1!D25="JF",Sheet1!E25,0))

is there a simpler formula to use so I dont have to add a condition every
time I add a row in sheet1?

Thanks,
Dan

 

[JE McGimpsey]

One way:

=SUMIF(D9100,"JF",E9:E100)

 

[Bob Phillips]

This is a bit simpler,

=SUMPRODUCT(--(Sheet1!D925="JF"),Sheet1!E9:E25)

--

HTH

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