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

Hi,

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

change range to fit your needs


"Carol @ Prison" wrote:

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

=COUNTIF(B1:B10,"Y")
where B1:B10 is the range with the "Y" or "N" values.
--
Rob Jordan
Powered by Creative Laziness


"Eduardo" wrote:

Hi,

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

change range to fit your needs


"Carol @ Prison" wrote:

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

=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
---

But it would give the same answer as it doesn't matter which column you're
counting (unless I'm not completely understanding the problem). And it's
simpler, easier to maintain, and more intuitive for less advanced users.

--
Rob Jordan
Powered by Creative Laziness


"Max" wrote:

=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
---

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
---
"Rob Jordan" wrote:
But it would give the same answer as it doesn't matter which column you're
counting (unless I'm not completely understanding the problem). And it's
simpler, easier to maintain, and more intuitive for less advanced users.