software

Problem below

14-Oct-06 ?5,000
30-Oct-06 ?15,000

How do I get this to show as:

Oct-06 ?20,000

Is there a formula to do this?--
Andy_Pimp
------------------------------------------------------------------------
Andy_Pimp's Profile: www.excelforum.com/member.php...oamp;userid=31990
View this thread: www.excelforum.com/showthread...hreadid=517243=quot;Oct-06 quot;amp;TEXT(SUMPRODUCT(--(MONTH(A1:A100)=10),B1:B100),quot;?#,##0quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Andy_Pimpquot; gt; wrote in
message ...
gt;
gt; Problem below
gt;
gt; 14-Oct-06 ?5,000
gt; 30-Oct-06 ?15,000
gt;
gt; How do I get this to show as:
gt;
gt; Oct-06 ?20,000
gt;
gt; Is there a formula to do this?
gt;
gt;
gt; --
gt; Andy_Pimp
gt; ------------------------------------------------------------------------
gt; Andy_Pimp's Profile:
www.excelforum.com/member.php...oamp;userid=31990
gt; View this thread: www.excelforum.com/showthread...hreadid=517243
gt;