Excel Workout 1 - Conditional Summation

Welcome to Excel Workout #1!

Difficulty Level:

This week’s challenge is designed to test your knowledge on conditional summation.

Conditional summation in Excel is the process of summing up a range of cells based on a certain condition. It involves using specific functions which allow you to specify one or more criteria that must be met in order for the cells to be included in the sum.


Please follow the directions given below, which include downloading the Excel worksheet required to perform the challenge tasks. Once you have completed the download, proceed to take the challenge and test your skills.


Make the necessary calculations in cells T5 and T6, using the most appropriate function in Excel, within the given conditions. Compare your answers with the values in cells V5 and V6.


Reply to this post with your formula code and solution file. Please be sure to blur or hide your formula code.


This workout will be released on Monday March 27, 2023, and the author’s solution will be posted on Sunday April 02, 2023.

Ilgar Zarbaliyev

Challenge #1.xlsx (8.3 MB)


Hi Ilgar,
Thanks for the workout, it is great to practice my excel skills again. I note that pineapple is outside the date range otherwise that would be included and given it was not case sensitive I was not sure how to deal with that scenario.

My formulas are:


Challenge #1.xlsx (8.3 MB)


Hi @KimC ,

Thank you for your reply.

1 Like

Been a while since used Excel like this! Thanks for the challenge.


Challenge #1.xlsx (8.3 MB)

1 Like

Hi There
Thanks for the refresher

Here is my solution

Note there are β€œ*” in the folumaes arround apple and bananas which doesn’t show up on the solution

Thanks again
Excel Workout Challenge #1 keith smith.xlsx (8.3 MB)

1 Like

Hi @Keith,

Thank you for your reply.

Will you upload your solution file?

Thaks in advance.


thanks Keith

1 Like

What a great way to start the day. thanks for the challenge. Keep them coming.
Challenge #1 - Quadri Solution.xlsx (8.3 MB)

My formula
Alternative Solution

Hi @QuadriAtharuOlayinka,

Thank you for your solution.

1 Like

You are most welcome

Thanks for brushing up on my Excel skills!

Here is my solution:


[Challenge #1.cleaned_Oksana Romanova.xlsx|attachment](upload://g0pYcMGaXoqX8BQwmp8uRGkBSi9.xlsx) (8.3 MB)

Challenge #1.cleaned_Oksana Romanova.xlsx (8.3 MB)


Hi Oksana,

Thank you for your solution.

AhmedMagdyChallenge #1.xlsx (8.3 MB)




Thank You so much, I really enjoyed the workout as it has been a long time not using excel.


Thanks for getting me to brush up on my excel skills but not your every day summation:


Challenge #1.xlsx (8.3 MB)

1 Like

Challenge #1 Franziola Chiu.xlsx (8.3 MB)

1 Like

Hi, I’m not using excel everyday as before, so this workouts will be great to refresh and even learn more.

Here is my solution.

Challenge #1_AA.xlsx (8.3 MB)


1 Like

If I am asked about apples, how can I include pineapple?

Still, I am going with your logic and have matched my answer.

I have used this method.

1. =SUMIFS(M5:M49, L5:L49, "*apple*", P5:P49, "<" & DATE(2021, 9, 9))

    L5:L49, "*bananas*",
    P5:P49, ">=" & DATE(2021, 8, 31),
    P5:P49, "<=" & DATE(2022, 2, 18)

Challenge #1.xlsx (8.3 MB)

1 Like

@QuadriAtharuOlayinka Great job. IFS is so much better than doing nested IF statements. Good choice!



Thanks for the challenge! Here’s my solution:


Challenge #1.xlsx (8.3 MB)

1 Like

Thank you for participating in the Excel Challenge related to conditional summation! I hope you found this challenge to be a fun and engaging way to improve your Excel skills and learn more about how to perform conditional summation in Excel.

Here is my solution to Workout #1:

The nuances to watch out for in this challenge were the following:

  • Using an asterisk (*) wildcard character that uses matches any number of characters

  • Using β€œ<>” Text Criteria Record that contain any nonblank entry

Here are the formulas:

  1. All Sold apples in kg until September 9, 2021
  • =SUMIFS(M5:M49,L5:L49,β€œapple”,L5:L49,β€œ<>pineapple”,P5:P49,β€œ<09-09-2021”)
  1. All Sold bananas in the period from 31 August 2021 to 18 February 2022
  • =SUMIFS(M5:M49,L5:L49,β€œbananas”,P5:P49,β€œ>=08/31/2021”,P5:P49, β€œ<=02/18/2022”)

You can find the file containing the solution below:

Challenge #1 with Solution.xlsx (8.3 MB)

Once again, thank you for participating in this Excel Challenge, and I look forward to seeing you in future challenges and learning opportunities!

1 Like