Excel – SUMIF and COUNTIF
Practice Excel SUMIF and COUNTIF interview questions. Learn how to sum and count based on conditions. Answer questions and receive feedback on correctness and approach. Ideal for data analyst and operations interview prep. First 2 questions are free with full feedback.
- Level Junior
- Questions 12
Try any track free — first 2 questions include full AI feedback. Subscribe to finish the track and unlock everything. Type or speak your answer — the first 2 questions include scoring and detailed AI feedback.
Sample excel – sumif and countif interview questions
Preview 6 questions from this track in quiz order. In the full quiz you answer one at a time — type or speak — then get a score and feedback.
-
What does SUMIF do?
What a strong answer includes
Sums values that meet a condition.
-
Write a SUMIF that totals sales for the “West” region.
What a strong answer includes
Correct range, criteria, and sum range.
-
What is the difference between SUMIF and SUMIFS?
What a strong answer includes
SUMIFS handles multiple conditions.
-
What does COUNTIF do?
What a strong answer includes
Counts cells that meet a condition.
-
Write a COUNTIF that counts orders over 100.
What a strong answer includes
Correct criteria.
-
How do you use SUMIFS with two conditions?
What a strong answer includes
Correct argument order.