Problem formula

  • Thread starter Thread starter Wiggy
  • Start date Start date
W

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??
 
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??
Click to expand...

It is possible and the HOW depends on HOW your months are entered in Column A.
--ron
 
They're listed as the names of months and e the sales dates in col L are as a
date.
Click to expand...

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

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

--ron
 
Back
Top