I've omitted the worksheet name, but have you tried something like this?

=SUMPRODUCT((MONTH($B$4:$B$123)=MONTH($A6))*E$4:$E $123)

Also, a Pivot Table may help. You can group dates by month, month and year,
etc.


On Thu, 6 Oct 2005 20:30:09 -0500, JustMe602
wrote:


{=SUM(IF((LEFT(TEXT($A6,"mm"),2))=((LEFT(TEXT('We ekly Total -
2005'!$B$4:$B$123,"mm"),2))),'Weekly Total - 2005'!E$4:E$123,"-"))}


Can this be simplified ....