Search Value By Few Conditions

Let's say I have 3 colums:
CarColorValueFiatgreen15VWred18BMWyellow25Fiatred13VWgreen14BMWred28fiatgreen13VWred23BMWgreen49fiatred13VWgreen15BMWred12fiatgreen14VWred15

Now, the point is, using which formula I can have:
1. the total value for all red BMW (value with two criterias in two columns)
2. The total value for all red and green BMW (value with three criteria, but in one columne there are two criterias)

The point is that:
1. My database is much much bigger than example
2. Adding some columns, rows, writing anything in database file is not interesting me, too much different criteria I have and different data to export from database
3. I am open to macros, so no problem.

I am using excel 2003.