I am summing monthly Invoice Amounts from an annual list of occurrence
using an array formula: SUM((MONTH(Range 1)=MONTH(A1)*(INVOICE for sam
Range 1)). It works perfectly for every month except January where th
amount is some very large unexplained number. The MONTH (Range 1) i
mmm-dd-yy and the MONTH(A1) is mmm. What is wrong

--
George
-----------------------------------------------------------------------
GeorgeF's Profile: http://www.excelforum.com/member.php...fo&userid=2412
View this thread: http://www.excelforum.com/showthread.php?threadid=37943