I have 3 columns in a spreadsheet
- Language (column A)
- Color (column B)
- Qty (column C)

I want one number which represents the SUM of all Qty, WHERE Language=E AND
Color=Red.  How can I do that?  I'm using the latest version of Excel.

Example:
*E     Red     3
E     Yel     4
S     Red     4
K     Red     5
*E     Red     2

The SUM would be 5 (adding the rows with asterick)

Thanks!