Sumproduct - please add extra funtionality

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hilton - 27 May 2008 15:37 GMT

Hi,

I need to use the sumproduct function but I would like to exclude 4
particular items which occur in a certain field

eg
SUMPRODUCT(($A$1:$A$1000 = FT)*($B$1:$B$1000 = 1)*($D$1:$D$1000))
works fine,

but now I need to exclude column C items which = RP, Sel, SP & Com

How do I do this?

Reply to this Message

Bernie Deitrick - 27 May 2008 16:24 GMT

Hilton,

SUMPRODUCT(($A$1:$A$1000 = FT)*($B$1:$B$1000 = 1)*($C$1:$C$1000 <> "RP")*($C$1:$C$1000 <>
"Sel")*($C$1:$C$1000 <> "SP")*($C$1:$C$1000 <> "Com")*($D$1:$D$1000))

HTH,
Bernie
MS Excel MVP

> Hi,
>
[quoted text clipped - 8 lines]
>
> How do I do this?

Reply to this Message