H
Hilton
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?
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?