That didn't work, I just ended up with #Name? in the cell.

Also the problem I have is that as with the dates the value apportioned
for each entry follow one another so I don't want to sum the column, it
looks something like this

Date Value
02/04/05 10000
12/05/05 12500
15/05/05 2500
21/05/05 10000
30/05/05 12500
02/06/05 12500

All I want to do is work out how many entries there are for each month
and then total up the associated values for that month, so in another
part of the workbook I want something like

Total Apr xxxx
Total May xxxx
Total Jun xxxx

Does this make sense?


--
Pjcan1
------------------------------------------------------------------------
Pjcan1's Profile: http://www.excelforum.com/member.php...o&userid=24277
View this thread: http://www.excelforum.com/showthread...hreadid=378924