Actually, all the formulas return zero in the absence of a match, so, use
the Sumproduct as a more efficient approach.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
One way, still keeping it as an *array* formula:

=SUM(IF(TEXT($A6,"mm")=TEXT('Weekly Total -
2005'!$B$4:$B$123,"mm"),'Weekly Total - 2005'!E$4:E$123,"-"))

If you could live with a zero instead of the dash ( - ), when no data
meets
the criteria, you could try this *regular*, *non-array* formula:

=SUMPRODUCT((TEXT($A6,"mm")=TEXT('Weekly Total -
2005'!$B$4:$B$123,"mm"))*('Weekly Total - 2005'!E$4:E$123))


"JustMe602" wrote
in message ...

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


Can this be simplified ....


--
JustMe602
------------------------------------------------------------------------
JustMe602's Profile:
http://www.excelforum.com/member.php...o&userid=27854
View this thread:
http://www.excelforum.com/showthread...hreadid=474003