Excel Formula Problem

[Carol @ Prison]

Is there anyone out there that can help me with a function please. My
objective is a formula which will read from a list of items and count them,
giving the result in a separate column/cell, ONLY if another cell in a column
says "Y" NOT counting the item if it says "N" ?

Thanks

 

[Eduardo]

Hi,

=SUMPRODUCT((A1:A10="??")*(b1:b10="Y"))

change range to fit your needs

 

[Max]

=COUNTIF(B1:B10,"Y")
I'm afraid the above won't satisfy what the OP wanted, which was a
conditional count of a col of items dependent on the status indicated in
another col (the "Y" or "N" in this instance). Eduardo's response shows one
way to get there which has been noted by the OP.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[Max]

I'd read OP as having sample data like this:

Item1 Y
Item2 Y
Item1 Y
Item2 N

where
Eduardo's: =SUMPRODUCT((A1:A10="Item1")*(B1:B10="Y")) returns 2
while your: =COUNTIF(B1:B10,"Y") returns 3

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik