Hi there!
This is a perfect example of when to use a pivottable in Excel. (insert tab > PivotTable). If you can include a sample workbook I can walk you through the steps needed to get the desired output specific to your data.
Or, you could create another column that contains only the month's number, using
=Month(A1) and then copying that down for the entire column; then, use a sumif formula like this:
- Code: Select all
=SUMIF(A1:A3,2,B1:B3)
Where the month column would be in column A, the amount to sum in column B, and the month for which you want to sum in the middle argument stated as a number.
hope this helps!
happy new year!