MASTERS OF EXCEL => Look in SUM Help needed

cjeasom · 24 Apr 2008 at 13:01

Im currently working out and equation that will help me with monthly sales, my equation is currently as follows;

=SUMIF(A5:A759,"<="&DATE(2007,5,31),AK5:AK759)-SUMIF(A5:A759,"<"&DATE(2007,5,1),AK5:AK759)

This equation works, and it sums the monthly sales (obviously relative to the date). However I want it to total the monthly sales relative to the employee.

A5:A759 = DATE
AK5:AK759 = CONTRACT VALUE

This is the new element that needs including in the SUM;

C5:C759 = EMPLOYEE NAME (ROB, PAUL, JOHN, ADAM, SIMON)

So the sum needs to use the employee name and total if the name is present within the SUM?

Does this make sense to anybody?

Any help would be fantastic.

Regards
Chris

xirokx · 24 Apr 2008 at 13:04

can i see your spreadsheet?

cjeasom · 24 Apr 2008 at 13:10

sorry

I cant mate, its a full breakdown of all the company I can't release it regrettably

Sorry I know this is not helpful in anyway

RimBlock · 25 Apr 2008 at 08:18

How about putting up a basic spreadsheet with 'noddy' data in the correct places for a few rows for only the part of the spreadsheet you want help with.

It would make it a lot easier to help if we could play around with a correctly stuctured example even if the data is junk.

RB