Problem formula

[Wiggy]

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??

 

[Ron Rosenfeld]

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

 

[Wiggy]

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

 

[Ron Rosenfeld]

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

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

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

--ron