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!
- 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!