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.

Try

=SUMPRODUCT(--(A1:A100="New York"),--(D1100="Yes"))

--

HTH

Bob

"LUIS ANGEL" <(E-Mail Removed)> wrote in message
news:bf398b36-d925-4083-89c7-(E-Mail Removed)...
> 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.
>