Mark,

Try this

=SUMPRODUCT((K9970%)*(K99<100%)*(B118=1)*(K78*'Ba se data'!$I$31))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mark D" wrote:

Good afternoon everyone

I have the following 2 formula's that are working perfectly for me

=(SUMPRODUCT((K99<70%)*(B118=1),K78*'Base Data'!$I$31))
=(SUMPRODUCT((K99100%)*(B118=1),K78*'Base Data'!$G$31))

I need one last formula that allows me to say if K9970% but less than 100%

Can anybody offer any help, I can't seem to enter it without getting an error