Formula with "if" "and" between two values "sumifs" data from pivot table

[NeilNeil]

Hi Mr. Excel,

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

 

[NeilNeil]

Hi All,

I added in an extra column that is used for the lookup. This removes the need for the range (which I never managed to get to work).

Thank you for all of your help.

Neil