Hey
I have a table with 3 columns
COLOR
NUMBER1
NUMBER2
An example can look like this:
<tbody>
</tbody>
Now i want to answer this question.
What is the total sum of Column Number2 with Column COLOR=Green and Column Number1=1
So Green have Two number1 column with the value "1"
So the answer should be 20 (10+10)
I am thinking something like this:
=SUMIF(A2:A8;"Green";B2:B8="1";C2:C8)
Or how should i write this?
I have a table with 3 columns
COLOR
NUMBER1
NUMBER2
An example can look like this:
Color | Number 1 | Number 2 |
Green | 1 | 10 |
Green | 1 | 10 |
Red | 2 | 20 |
Green | 2 | 20 |
Yellow | 3 | 30 |
Red | 3 | 30 |
Green | 4 | 10 |
<tbody>
</tbody>
Now i want to answer this question.
What is the total sum of Column Number2 with Column COLOR=Green and Column Number1=1
So Green have Two number1 column with the value "1"
So the answer should be 20 (10+10)
I am thinking something like this:
=SUMIF(A2:A8;"Green";B2:B8="1";C2:C8)
Or how should i write this?