On Tue, 6 May 2008 04:48:02 -0700, Wiggy
wrote:

They're listed as the names of months and e the sales dates in col L are as a
date.

"Ron Rosenfeld" wrote:

On Tue, 6 May 2008 03:50:00 -0700, Wiggy
wrote:

I know that this is probably a simple fomula to write, but I'm havingno luck
at all in getting it to do what i want.
Sheet1, col i is a sales figure
Sheet1, col L is a sales date
Sheet2, col C is total monthly sales with the months listed in Col A same
sheet.

I want to automatically add the right sales into the right monthly figures
without having to do it manually, bareing in mind that sheet 1 may not be
entered in a chorological order.
Is this possible and if so, how??

It is possible and the HOW depends on HOW your months are entered in Column A.
--ron


Guessing at how you have your data, you might try:

=SUMPRODUCT((TEXT($L$1:$L$100,"mmmm")=A1)*$I$1:$I$ 100)

--ron