Need Help with a Formula

[Guest]

I need to count the number of entries on sheet where

column D=ROUND

and

column E>=.01 AND less than .04

and

column F is "D" OR "E" OR "F"

What is throwing me is the last part that calls for the
"or" functionality.

This does not work:

=SUMPRODUCT(((Inventory!D52000="ROUND")*(Inventory!E5:E2000>=0.01)*(Inventory!E5:E2000<0.04)*(OR(Inventory!F5:F2000="D",Inventory!F5:F2000="E",Inventory!F5:F2000="F"))))

It returns a value that basically ignores the column F entries.

Any help would be greatly appreciated.

Thank you!! - Paul

 

[RagDyer]

Please *DON'T* multipost !

See your answers in the Functions group.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

I need to count the number of entries on sheet where

column D=ROUND

and

column E>=.01 AND less than .04

and

column F is "D" OR "E" OR "F"

What is throwing me is the last part that calls for the
"or" functionality.

This does not work:

=SUMPRODUCT(((Inventory!D52000="ROUND")*(Inventory!E5:E2000>=0.01)*(Invent
ory!E5:E2000<0.04)*(OR(Inventory!F5:F2000="D",Inventory!F5:F2000="E",Invento
ry!F5:F2000="F"))))

It returns a value that basically ignores the column F entries.

Any help would be greatly appreciated.

Thank you!! - Paul