Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Below is the data:

A          B          C
xxx        2          5
xxx        3          4
bbb        2          3
bbb        2.5        2
nnn        1.5        2
nnn        2          1

I want to subtract the amount in column B & C with the same description in column A

share|improve this question
Subtract from what? – Shevek Jun 28 '10 at 8:17
Please show us the results you want using the data you have provided. That will help us to understand your question. Thanks. – Mike Fitzpatrick Jun 28 '10 at 8:37

If you actually mean add columns B & C where column A is the same then what you want is a Pivot Table

share|improve this answer

If think what you are looking for is to use sumif(). For example if you use


You will get a value of 3.5. If you then do


You will get a value of 3. Take one away from another and you get 0.5. Does this suffice or are you looking for something more sophisticated?

share|improve this answer

You can create a pivot table as Shevek says and then create a calculated field to do the subtraction and it should be automatically added to the pivot. You could also just add another column that did the subtraction and add that to the pivot.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .