Excel Formula Help!!!

[cjeasom]

Im currently putting a list of jobs that we have performed into a database in excel.

I have worked out profit, loss, values, averages and so forth. Now I want to analyse who has sold the most.

I have about thirty colums in this database and I was wondering if anyone could help me with this formula.

Column C4 - C161 is a column called "Job Created & Costed By" it contains the individuals names in this instance "CHRIS".

I then have a column called "TOTAL CONTRACT VALUE", this range is "AB4 - AB161.

I want to create a query that if the name "CHRIS" appears in columns C4-C161, then can it add together the values in AB4-AB161 that belong to "CHRIS"

Can anybody help me out with this!?

Cheers
Chris

 

[Majago]

Have a look at this website, might have what you're after there

Otherwise could you not filter by column C then select 'Chris' and then just sum column AB?

 

[kaiowas]

=SUMIF(C4:C161,"CHRIS",AB4:AB161)

 

[cjeasom]

cheers mate, your a star, I had been doing the filter thing but knew there was a better way!

 

[wsurfa]

pivot table might be a better route,as you should be able to set up to get total value, total number, avg cost etc