Formula help

[Mike B.]

I'm trying to exclude two lines from a sumif that are by
using the following formula, but it's not returning the
right answer. Is there a simpler way without tying to an
individual cell? =SUMIF
(PRODUCTION$B$3:$B$242,"F",PRODUCTION!$L$2:$L$242)-
(SUMPRODUCT((PRODUCTION!$B$2:$B$242="F")*(PRODUCTION!
$D$2:$D$242="SP")*(PRODUCTION!$L$2:$L$242))+SUMPRODUCT
((PRODUCTION!$B$2:$B$242="F")*(PRODUCTION!$D$2:$D$242="SQ")
*(PRODUCTION!$L$2:$L$242)))

 

[Paul Corrado]

Mike

It looks like you want to include column b items = f and exclude column d
items = SQ or SP

=SUMPRODUCT(($B$2:$B$242="F")*($D$2:$D$242<>"SP")*($D$2:$D$242<>"SQ")*($L$2:
$L$242))

PC

 

[Mike B.]

Right on target! Thanks, Paul...

-----Original Message-----
Mike

It looks like you want to include column b items = f and exclude column d
items = SQ or SP

=SUMPRODUCT(($B$2:$B$242="F")*($D$2:$D$242<>"SP")*