I am stuck on the following formula.

=IF(OR(Nmd1>="200",Nmd1<"300"),SUMIFS(A1,Nmd2,'Sheet1'!$A161),"0")

Nmd1 & Nmd2 are both named ranges that link to data in a pivot. Example as follows "=+'DATA PULL DOWN FROM SYSTEM'!B4995"

This formula works, but I need this to return the results Nmd1 => "200" and < "300". I have used "and" instead of "or", but it is not providing the results.

The intention is to use a variation of this within a larger formula, so it will appear 12 times. Happy to provide further details if needed.

Wisdom very much appreciated

Kind Regards,

Neil