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.
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.
100="Yes"))