Is there a way to search a date column for a date range and then if the date falls within a certain range, I would like to include any amount ordered within that date range in a sum. If the dates are outside that range, do not include the number ordered

Question

Column A has different dates upon which product was ordered

Column b has the number of product that were ordered on that date

I want to sum up all the orders from, for example, October only. What is a formula to use to search column A for only dates that fall in October and then include only those orders in the sum?

Answer 1

The SUMIFS function will what you want.

SUMIFS(B1:B10,A1:A10,">="&DATE(2024,10,1),A1:A10,"<="&DATE(2024,10,31))

However, if you plan to change the date range frequently, updating the constants in the formula is cumbersome. I find it easier to put the start and end dates is some otherwise unused cells and reference those cells in the SUMIFS function.

Answer 2

Hi,

Try this formula:

=SUMPRODUCT((MONTH($A$2:$A$17)=E2)*$B$2:$B$17)

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.