Adding totals of cells depending on contents of another cell

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
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
 
Back
Top