Does this work?
=SUM(MONTH(B5:B12)=MONTH(B15),C5:C12)
Once entered don't just hit enter, use Ctrl+Shift+Enter and it should
generate an array formula.
Regards,
A
"stuarthow" wrote:
Hi
Need some help with the SUMIF() function on Excel 2003 please:
Im using this function as per example €“
=SUMIF(month(B5:B12),month(B15),C5:C12)
where B5:B12 are regular dates (dd/mm/yyyy), B15 is a €˜month date (mmm
yyyy) and C5:C12 are ordinary numbers.
When entered, I get returned the warning box €˜The formula you typed
contains an error
Help would be gratefully welcome.
Stuart
--
stuarthow
------------------------------------------------------------------------
stuarthow's Profile: http://www.excelforum.com/member.php...o&userid=25417
View this thread: http://www.excelforum.com/showthread...hreadid=388975