excel - SUM a date range within another sheet

Question

I would like to SUM a date range on another sheet ("TRADES") (the date range is ALL of January and the date column is column B:B, but this also includes all the other months of the year)

And the column i would like to SUM is column N.

Any help is appreciated!

I am currently trying this, but it is not working:

=SUMIF(TRADES!N:N,TRADES!B:B, ">="&DATE(2021,1,1), TRADES!B:B, "<="&DATE(2021,1,31))

question from:https://stackoverflow.com/questions/65883862/sum-a-date-range-within-another-sheet

Answer 1

This base formula should work. You will need to update the following:

• Sum Range on TRADES worksheet
• Date Range on TRADES worksheet
• Cell/Formula reference for the first of the desired month you wish to sum (January = 1/1/21)

=SUMIFS(TRADES![SUM RANGE],TRADES![DATE RANGE],">="&[Cell Ref to Start of Desired Sum Month],TRADES![DATE RANGE],"<="&EOMONTH(Cell Ref to Start of Desired Sum Month,0))

If you need further explanation, see this resource: How to sum by month - SpreadsheetWeb