Excel 2010 - Add up rows depending on dropdown value

[Badgers]

Hi,

I building an excel sheet for eg;

Date Transaction Value
01/01/2010 Service Charges £100
01/01/2010 Maintenance £50
02/01/2010 Service Charges £10

The Tranaction is a dropdown so what I want to do for each item is add up all the Value fields and display and overall summary at the bottom of the spreadsheet. For eg;

Service Charges: £110
Maintenance: £50

Any help would be great.

Thanks

 

[SkipVought]

hi,

1) Use the SUMIF function

2) WHY "display and overall summary at the bottom"???

This is the twenty first century! It is not the age of paper, pencil and adding machine! The old ledger toting bean counters HAD to subtotal each page and put the total at the 'bottom'. Everyone knew where the 'bottom' was, cuz you could see it when you opened the leger.

Now we have slick electronic spreadsheets, where the 'bottom' could be on line 10, 100, 1000, 10,000... who knows where???

Why force your user to hunt for 'the bottom line' when 'the bottom line' could be just like Bob Uecker, in the 'FRONT ROW' or, in this case, the 'TOP ROW'?

As a practice, I nearly ALWAYS put totals and summaries at the TOP of tables and reports. It makes sense and users, like VPs, appreciate it.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]