Hi Chris,

Am Tue, 16 Jul 2013 13:09:22 -0700 (PDT) schrieb Chris Smith:

=SUMIF(MONTH('Sheet1'!$D$6:$D$1008),4,'Sheet1'!O$6 :O$1008)

try:
=SUM(IF(MONTH(D6:D1008)=4,O6:O1008))
and enter the array formula with CTRL+Shift+Enter
or:
=SUMPRODUCT(--(MONTH(D6:D1008)=4),O6:O1008)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2