Adding totals of cells depending on contents of another cell

[David]

Hi All,

I am working on a Excel 2007 workbook which tracks sales made by our
company. We have two columns 'Total Agent Commission' and 'Total Company
Profit' then another column with 'Order Status' there are three status's
used "D, F & C".

What I need to do is calculate the total of the Agent Commissions and
Company Profit based on the status of the order, i.e. I need to know the
total of the all the orders with a status of D etc etc.

Could someone tell me what formula I would need to use to work this out?

Thanks

 

[Bernard Liengme]

Have a look at SUMIF in Help then come back if all is not clear
best wishes

 

[David]

Hi,

Thanks for the fast response, and what you suggested was exactly what I was
looking for. I know if might have sounded like a stupid question but my
knowledge of Excel is limited!

Thanks again