HELP: Condition Summing Question

  • Thread starter Thread starter Cirene
  • Start date Start date
C

Cirene

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!
 
One way:

=SUMPRODUCT(--(A1:A5="E"),--(B1:B5="Red"),C1:C5)

Better to use cells to hold the criteria:

E1 = E
F1 = Red

=SUMPRODUCT(--(A1:A5=E1),--(B1:B5=F1),C1:C5)
 
Back
Top