multiple criteria with wildcard

[Dookie]

Please help...
I have this board

a b c
CARS 0800/0900 10
CARS -/1000 20
CARS -/1300 12
TRACKS 1500/- 15
TRACKS 1700/- 20
TRACKS 1700/1800 21
BIKES - 8
BIKES -/1800 9
BIKES 10

I want to count the for eg the cars (column a) which departed from my station (-/???), or to count the tracks which arrived and departed from my station (????/????).
I'm using these formulas:
SUM((A1:A9="CARS")*(ISNUMBER(SEARCH("-/";B1:B9;1)*C1:9)))
or
SUMPRODUCT((A1:A9="CARS")*(ISNUMBER(SEARCH("-/";B1:B9;1)*C1:9)))
and both of them gives me back 2 (the number of cells), not the count of the cars that match with my criteria (20+12=22)

Thank u in advance for your support!!

 

[Gerald Higgins]

Well to begin with, I think 20+12=32

Try this

=SUMPRODUCT(--(A1:A9="CARS"),--(LEFT(B1:B9,2)="-/"),C1:C9)

 

[Aladin Akyurek]

All versions...

=SUMPRODUCT(
   --(A1:A9="CARS");
   --ISNUMBER(SEARCH("-/";B1:B9);
   C1:C9)

which yields a sum, not a count.

Also a sum on Excel 2007 or 2010...

=SUMIFS(
    C1:C9;
    A1:A9;"CARS";
    B1:B9;"*-/*)

Replace semi-colon with comma if you are on American system.