I know that this is probably a simple fomula to write, but I'm having no 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 the monthly sales figure


I want to automatically add the sales into the right monthly figures
without having to do it manually, bareing in mind that sheet 1 may not be
entered in a chronological order.
Basically, if L6=(a date in june) add i6 to Sheet2 c3
if L12=( date in june) add i12 to sheet2 c3
if L9=(a date in july) add i9 to heet to c4
Anyone any ideas?? I've started to pull my hair out!!