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

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.

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.