Consider the spreadsheet given below:
|
|
A |
B |
C |
|
1 |
Project |
Number of Days |
|
|
2 |
A |
15 |
|
|
3 |
A |
20 |
|
|
4 |
B |
30 |
|
|
5 |
A |
10 |
|
|
6 |
B |
10 |
|
|
7 |
A |
5 |
What is the output of the following formula in Cell C1?
=SUMIF (A2 : A7, "A", B2 : B7)
1
90
2
80
3
50
4
20