Greetings,

I am trying to get the sum of a column of numbers (column E) if the
date in column A is within the same month and year of the date in the
row this formula is sitting in. This sheet covers several years.

What I have so far is this formula sitting in E10 (the cell where I
want the sum to be):

=SUMIF($A:$A,$A10,E:E)

Row 10 is used only as a monthly divider and monthly subtotals (For
this example). Column A is formatted as date in the "mm dd, yy"
format.

With values in column E that should return a sum total, I am instead
getting "$0.00". My criteria ($A10) is not working.

How can I change the criteria to look at only for the "mm, yy" of
column A's "mm dd, yy" entries and not the full "mm dd, yy" date?

Any help will be greatly appreciated.

-Minitman