Hi Guys,

I'm trying to use a named Range in a Sumproduct Formula however what i want
to do is return the total of all the cells which contain values not in the
range.

So similiar to this Formula :

=SUMPRODUCT(--(FEB!$H$2:$H$311<STDGL),--(FEB!$I$2:$I$311=STD),--(FEB!$F$2:$F$311))

But I need to alter it so it only sums the cells F2:F311 that dont contain
the values in STDGL for cells H2:H311 or in STD for cells I2:I311

that make sense ?

Thanks Guys

Michael -