=QUERY(取込!A1:D6,"select A, C where B = '東京'",1)

=FILTER(取込!A2:D6,取込!B2:B6="東京")

=VLOOKUP(A8,取込!A2:D6,3,FALSE)

=COUNTIF(取込!B2:B6,"東京")

=SUMIF(取込!B2:B6,"東京",取込!C2:C6)

=SUMPRODUCT((取込!B2:B6=B11)*1)

=VALUE(取込!D4)
