Need Help with a Formula

  • Thread starter Thread starter Paul
  • Start date Start date
P

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!D5:D2000="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
 
Try this:

=SUMPRODUCT((D5:D2000="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!D5:D2000="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
 
Hi Pail,

Try this

=SUMPRODUCT(((Inventory!D5:D20="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!D5:D2000="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
 
Back
Top