I tried to get totals per months of a list of transactions:
Col B: date in yy-mm-dd (dates are not always in chronological order)
Col C: transaction decription (not needed)
Col D: amount
Cells I9 to I20 month in numbers 1 - 12
I would like to have the totals per month in cells J9 to J20
I have tried
in J9 (total for January):
=SUMIF(B$9:B$910;MONTH(B$9:B$910)=I9;D$9:D$910)
in J10 (February):
=SUMIF(B$9:B$910;MONTH(B$9:B$910)=I10;D$9:D$910)
The formula returns no error, however the result is always 0 (zero).
What is wrong in this formula?
Thanks for your help,
Paul
Col B: date in yy-mm-dd (dates are not always in chronological order)
Col C: transaction decription (not needed)
Col D: amount
Cells I9 to I20 month in numbers 1 - 12
I would like to have the totals per month in cells J9 to J20
I have tried
in J9 (total for January):
=SUMIF(B$9:B$910;MONTH(B$9:B$910)=I9;D$9:D$910)
in J10 (February):
=SUMIF(B$9:B$910;MONTH(B$9:B$910)=I10;D$9:D$910)
The formula returns no error, however the result is always 0 (zero).
What is wrong in this formula?
Thanks for your help,
Paul