Hello,

I need a formula to do the following.

Column A = ascending dates, e.g. 01/01/07, 02/01/07 etc
Column B = a figure corresponding to its date in column A

I then have different cells corresponding to the 12 months. I need each of
these to show the total figure from column B but only those from its specific
month. So, I could do with an example of a formula to use. Let's say the
total for January will be in cell C2. What formula would I put in that cell
to make a total for column B, but only for items from January (the dates
being in column A)?

This is a clarification of an earlier post which may have been too confusing
as there have been no replies.

Many thanks!