Need Help with a Formula

[Paul]

I just (incorrectly) posted this in the General forum, so
sorry for the double post.

Anyway, 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]

Try this:

=SUMPRODUCT((D52000="Round")*(E5:E2000>=0.01)*(E5:E2000<0.04)*(F5:F2000={"
D","E","F"}))
--

HTH,

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


I just (incorrectly) posted this in the General forum, so
sorry for the double post.

Anyway, 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

 

[Bob Phillips]

Hi Pail,

Try this

=SUMPRODUCT(((Inventory!D520="ROUND")*(Inventory!E5:E20>=0.01)*(Inventory!
E5:E20<0.04)*(Inventory!F5:F20={"D","E","F"})))

--

HTH

RP

I just (incorrectly) posted this in the General forum, so
sorry for the double post.

Anyway, 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

 

[Guest]

Thank you. Thank you. Thank you!!!!

It worked.

- Paul