Riddle from Excel

Here is a riddle from Excel that will test your skills and understanding of some program functions:

Riddle

You have an Excel sheet with two columns of data. Column A contains dates from January 1 to December 31 of a given year. Column B contains random sales values from the same period. Your task is to find the sum of sales, but only for the spring months, which are March, April, and May.

Question

What formulas or steps would you take to solve this task in Excel?

Hint

If your system uses a different date format (e.g. day before month), adjust the format in the formula accordingly.

Here is a riddle from Excel that will test your skills and understanding of some program functions:

Riddle

You have an Excel sheet with two columns of data. Column A contains dates from January 1 to December 31 of a given year. Column B contains random sales values from the same period. Your task is to find the sum of sales, but only for the spring months, which are March, April, and May.

Question

What formulas or steps would you take to solve this task in Excel?

Hint

If your system uses a different date format (e.g. day before month), adjust the format in the formula accordingly.

Show original content

2 users upvote it!

3 answers