countif and vlookup


L

LUIS ANGEL

Good afternoon.

Im trying to figure out the best way to use a formula for the
following:

my table has column A with a list of cities(these cities have many
entries in the list) and column D with a list of codes(yes or no, just
to simplify the example.). this is on sheet 1.

in sheet 2 i want to be able to place a formula that would look up for
example how many new york entries have a yes on column D.

I was trying something like:

=countif(vlookup(sheet1!"new york",sheet1!$a$1:$d$200,4,false)

but this will olny stop at the first one and i want to know how many
in total.

Any thoughts? if there is a better way, please let me know.
 
Ad

Advertisements

D

Dave Peterson

Check your other post.

Good afternoon.

Im trying to figure out the best way to use a formula for the
following:

my table has column A with a list of cities(these cities have many
entries in the list) and column D with a list of codes(yes or no, just
to simplify the example.). this is on sheet 1.

in sheet 2 i want to be able to place a formula that would look up for
example how many new york entries have a yes on column D.

I was trying something like:

=countif(vlookup(sheet1!"new york",sheet1!$a$1:$d$200,4,false)

but this will olny stop at the first one and i want to know how many
in total.

Any thoughts? if there is a better way, please let me know.
 
Ad

Advertisements

Joined
Jul 8, 2009
Messages
6
Reaction score
0
Use the PivotTable feature. This should give you a neat table of cities & the respective frequencies of the Yes & the No in column D.
Hope this helps.
 

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

Top