sum based on category

I'm looking for a way to add up the values of duplicate rows underneath the original then delete the duplicate afterwards, whether this is through VBA or just formulas. I can't really think of any way other than using the IF function such as =IF((A2=A3)*(B2=B3),"",SUM(C$<wbr style="font-family...

Hi I have data laid out like below, I am trying to write a formula to go through 1000's of rows in column B (Category) then display all of the records once and add up the totals e.g. CCON $123.04 COTH $456.06 I have been able to do this with...

Hi, I have simple table: <tbody> A1: Country B1: Value A2: Poland 10 A3: USA 5 A4: Germany 2 A5: Poland 5 A6: UK 3 A7: Germany 3 A8: Poland 2 A9: Total =Sum(B2:B8) = 30 </tbody> Now when I'm using filter and select Country = Poland, the total should be: 10+5+2=9. But always...

Basically, I am able to calculate the total hours in operations. Now, I need to sum the hours in Operations that fall between 9:00pm and 8:00 am. <colgroup><col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181; mso-outline-level: 1;"> <col width="87" style="width...

This is my first post so please (kindly) let me know if I made an error in my question - and I apologize in advance if any are made. I have 5 possible shifts (1-5) in this Shift column. For each Job Code in the 1st column I need to somehow merge each Job Code into 1 total 'qty' per each shift...

Looking to tally scores based on name and category. However the original table layout is unconventional (Excel speaking) and I cannot change the output that comes from a webpage query. I want to sum the scores across all tabs (month) first by category (ie., CB, PB, CI, CM etc) and then by name...

I have a bunch of data the columns of concern are the account name, Country, % of Assets. There are several occurances of each account name (rows). What I would like to do is sum all of the % of assets for each country per account. My final output should look like this...

I have the following data with the rows showing hours individuals have worked by columns showing the week-start date. The source data is split into a task breakdown so the same person can appear more than once. I need to consolidate the information. I would like to do something like SUM 1/4/11...

In Excel 2007 am preparing an expense report and need to know how to sum up all dollar amounts according to their defined category. Here is an example of the layout of my spreadsheet... Date Description Amount Category 1/1/11 Joe's Fuel Depot...