count 1 cell in column based on value in another cell

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a table that looks like the following

one Y
one
two
two
three Y
three Y
three

What I am trying to do is count the numbers of Y's based on the value in the
first column


ie......count y's if column 1 = 3

Thanks
Tim
 
Is that 3 or three?

=SUMPRODUCT(--(A1:A100=3),--(B1:B100="Y")

or

=SUMPRODUCT(--(A1:A100="three"),--(B1:B100="Y")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

For Eachcell in Range tranpose comma seperated values to a list in D 4
Permutations andText to column problem 6
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Using the FIND function in a loop 2
Range passed to a function - trying to just move through the range 4
Function needed to pull in cell values 9
macro to copy columns from one sheet to another sheet 4
Compare Two Columns 3

Back
Top