Consider the spreadsheet given below: A B C 1 Project Number of Days 2 A 15 3…
PYQ UGC NET 2022
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)- A.
90
- B.
80
- C.
50
- D.
20
Attempted by 4 students.
Sign up free to check your answer
Sign up freeLoading lesson…

