Summing Column A based on dates from Column B

[nurikabe]

Is it possible to sum one column based on the month and year of values in another? I have tried this:

=SUMIF(G8:G17,"=2002-10",C8:C17)

Without any luck. This will only work when the dates have been entered as the first of the month.

Is there a better way to do this than with SUMIF?

 

[Aladin Akyurek]

On 2002-10-12 04:50, nurikabe wrote:
Is it possible to sum one column based on the month and year of values in another? I have tried this:

=SUMIF(G8:G17,"=2002-10",C8:C17)

Without any luck. This will only work when the dates have been entered as the first of the month.

Is there a better way to do this than with SUMIF?

=SUMIF($G$8:$G$17,"="&MONTH(E1)&"-"&YEAR(E1),$C$8:$C$17)

where $G$8:$G$17 houses true dates and E1 the date value 10/01/2002 in the mm/dd/yy format.

Try this to see whether it works. If not, there is a different, but expensive, formula you can use.