Formula Problem

[Puddycat]

I am unable to get this formula to work. It seems simple enough. Can anyone help me with what is wrong? I am trying to get have the formula look for the presence of both items and return the count if it meets both conditions.

{=COUNTIFS{'Piping List'!C3:C17635={"High","Medium","Low"},{'Piping List'!D3:DC17635={"P-160"}}}

 

[Firefly2012]

Hi

untested but try:

=SUM(COUNTIFS('Piping List'!C3:C17635,{"High","Medium","Low"},'Piping List'!D3:D17635,"P-160"))

This formula does not require array-entering.

I noticed your second range encompassed more than one column - was this intentional?

 

[Puddycat]

Yes that is intentional. I tried your formula, but it returns a TRUE statement. I need to get a count of the items that meet both conditions.

 

[Robert Mika]

Put this into column DD3 copy down
=COUNTIF('piping list'!D3:DC3,"P-160")
the use
=SUMPRODUCT(--('piping list'!C3:C17635={"High","Medium","Low"})*('piping list'!DD3:DD17635))

 

[Puddycat]

That doesn't work either. Is there anyway to send you the file I am working with so that you can see what I am trying to do?