Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif and vlookup
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif and vlookup
Try
=SUMPRODUCT(--(A1:A100="New York"),--(D1:D100="Yes")) -- HTH Bob "LUIS ANGEL" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif/Vlookup | Excel Discussion (Misc queries) | |||
countif and Vlookup | Excel Discussion (Misc queries) | |||
COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
countif w/vlookup | Excel Discussion (Misc queries) | |||
Countif or Vlookup | Excel Worksheet Functions |