This is a dynamic worksheet with new rows added daily throughout the year. I want to get monthly totals from the data so I can create a line chart on the monthly totals.
Column A is DATE
Column B is Amount
In cell E2 I want to SUMIF the month in the date range is 1
In cell F2 I want to SUMIF the month in the date range is 2
In cell G2...SUMIF month...is 3
and so on
I tried variations of =SUMIF(A:A,MONTH(A:A)="1",B:B) and =SUMIF(MONTH(A:A),"1",B:B)
Thank you!
Bookmarks